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.
Export the existing product list from the products dashboard (Administration -> Products -> List Products -> Export Products). If you only need to update a subset of your products, you can use Advanced Export to only export a set list, such as just products from one supplier only.
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 spreadsheet is edited in plain text format if possible. If you want to be 100% sure no data is auto-formatted, it is highly recommended you import the .csv instead of opening it in Excel or Google Sheets.
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 (Administration -> 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.