Pre Import
Before we do the import, we need to wipe out the values in the Temp Price field. We use this field to determine if products need to be removed from the store (this field won't get updated but the others will).
- Go ahead and backup the database. We're going to be making many changes and it'll be good to be able to roll back tables if needed. Be cautious not to wipe out any orders when you do this, though.
- Edit 'site/script_preimport'
- Modify the entry ids at the top. These options will allow you to batch the script so it doesn't error out or just focus on certain entries.
- Next, modify the category value to match the cat_id of the Manufacturer category you're uploading. Prefer to do one at a time.
- 353 - Eagle
- 354 - Kul
- 577 - MPD Medical
- 578 - Omaha Custom Manufacturing
- 579 - Quantum Medical
- 580 - Rousseau
- Save the script
- Run the script - https://storageandcarts.com/script_preimport
Now we actually need to run the import.
- Upload the file to /temp, overwrite the existing file from the manufacturer
- Go into DataGrab
- Choose the correct import
- Run the import from the dashboard or batch it if you need to using the Import URL
- Check the report and make sure there aren't any concering errors
- If there are, fix in the CSV and rerun the import
Now, the entries have been updated and added and all of the existing entries will not have an empty Temp Price. You'll want to have completed all of your desired uploads at this point.
- Modify the entry_ids of the 'site/script_colormods' and 'site/script_removeitems' scripts to control the range of entries.
- Run the removeitems script - https://storageandcarts.com/script_removeitems
- This will close any items with no Temp Price
- Run the colormods script - https://storageandcarts.com/script_colormods
- This will add a Color modifier to entries with multiple color categories that don't already have a Color modifier field