Totally Zenned
- Join Date:
- Jun 2005
- Location:
- Cumbria, UK
- Posts:
- 10,327
- Plugin Contributions:
- 0
Easy Populate 1.2.5.4 support
PatF:
Hi all,
Forgive me for asking a question which has no doubt been asked before but I couldn't find it when searching the thread.
What happens when a store already has products that never used model numbers ?
Well actually I know the answer to this :oops:
When downloading the product file for the first time non of the products had model numbers. After I assigned model numbers to these products and uploaded the file easy populate created new products for each model number. However the old products were still there so basically I was left with each product on the system twice - the original unmodeled one and the created by easy populate modeled sku.
No major issue caused as I had a backup to restore but what's the best way around this (other than assigning model numbers first before running easy populate - we have 5,000+ products in the database)
Assigning MODEL NUMBERS (in your case) cannot be done with Easy Populate, as EP uses the Model Number field as a PRIMARY reference. This makes sense, as SKU protocol is almost always a case of a SKU number living and dying with an individual, single product. All formal retailers work on this basis. Go into any supermarket and look at the UPN/EAN/SKU/BARCODE . It is UNIQUE on every product. If a product goes off the market, the SKU number goes with it. It is NEVER used again, for any product.
Your solution is to use SQL to update your product list. Even with 5000 products, this is not too difficult a task - but can be a bit time-consuming.
You will only be able to use EP after you have done these updates via SQL first.
