WorkGuru allows you to update all product fields except for the SKU in bulk via a CSV file. This is handy for ongoing product information such as price changes etc. When importing products back into WorkGuru, if the SKU matches, it will update that product. If it the SKU doesn't match it will add the products.
From the products dashboard Actions menu, you can Export All Products for a full product list including inactive products. Or, if you only need to update a subset of your products, you can Advanced Export to only export a refined product list, such as inactive products only or just products from the one supplier.
Open the downloaded WorkGuruProductExport.csv file in your spreadsheet editor of choice. Be aware of spreadsheet editors auto-formatting data fields (removing leading 0's, dates, barcodes etc). It is recommended the csv is imported into your spreadsheet editor instead of opening it in Excel or Google Sheets and is always edited in plain text format.
You can update every column in the export EXCEPT for the SKU. For example, you can use your normal spreadsheet tools to increase the SellPrice by a required percentage etc. When you have finished the changes, save or export the .csv. NOTE: You don't need to re-import all the rows in the spreadsheet, technically you can remove everything except for the rows you changed. You do need to retain all the columns though.
From the product import page (Products -> Import Products), or Import Products from the Actions menu.
Click the Choose file button, select the updated product .csv and click Save to process the update.
WorkGuru will process the import file and then display a preview summary of what actions will occur. As you are updating current product information, only Existing Products should be listed in the preview.
Note: When updating existing products, it is extremely important to confirm this preview as there should be NO NEW products created!
If the preview summary is displaying NEW products, it means there is SKU's on your import that DO NOT match existing products. Check your import spreadsheet's SKU column to ensure:
- Your spreadsheet application has not auto-formatted your product SKU's
- No un-intentional typo's etc
- No hidden leading or trailing whitespace
Click Confirm and Create Products to import and update your products to apply the changes in your import spreadsheet.
Was this article helpful?
That’s Great!
Thank you for your feedback
Sorry! We couldn't be helpful
Thank you for your feedback
Feedback sent
We appreciate your effort and will try to fix the article