usengines Posted April 23, 2019 Share Posted April 23, 2019 We have more than 100,000 products to import. When we import similar products such as models in a series PrestaShop keeps overwriting one item with another. For instance we have 104M02-0021-F1 and 104M02-0196-F1. If we import either of them using the model number as the ID and the name and then import the other it overwrites the other as prestashop is only using the first three characters of the number. More dangerously it keeps the price of the first item imported which is often much different than the other depending on such features as electric start. We have tried using the reference as the key but it still overwrites the other product. We are using 1.6.23 as the most important modules we use are not compatible with 1.7 namly Authorize AIM and both the FEDEX and UPS carriers. Link to comment Share on other sites More sharing options...
usengines Posted April 25, 2019 Author Share Posted April 25, 2019 The basic problem is that the ID in CSV only accepts numbers. This produces another problem in that the ID then is different from the manufactures and that makes it difficult to maintain a shop when products are being discontinued, superseded and added. One would think that the solution then would be to use the UPC or EIN number, however not all the products have those assigned. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now