For stores with large inventories, using StoreHub’s csv import can make managing items more efficient. Add your items to the list all at once using this feature.
To easily apply a change in pricing or tax code to a group of products, we need to first download the items that need to be selected. At the Default Price Book, click ‘Download’. Your default Price Book should be downloaded.
Open the downloaded file using a spreadsheet editor. You will see that the file consists of all your products with their details. Identify the products that require a change in pricing or tax code, and specify the new values in the file. Save the file once you’re done.
Note: If you change the tax name, please make sure that the specified tax name matches an existing tax code in your Tax Code section at the Backoffice.
If you can remember the SKU of your product, instead of downloading the full list of your products, you could download a blank template and key in your products. To do that, in your Price Book, select ‘Import Items by CSV’, and click ‘CSV template’ to download it.
Open the downloaded template, and delete the test product within it.
Now you can fill your template with your products and their order info. Each product requires either an SKU or Product Id.
There are 2 ways that you can find out the product ID:
At Products > Manage Products, search for your items, and click ‘Export to CSV’. Within the downloaded file, at the most right column, you should see the Product ID.
At Products > Manage Products, search for your items, and click into the item. Take a look at the URL, the group of text behind ‘id=’ is the Product ID for the product.
Once all changes have been specified and saved, you are ready to import the file back into the Backoffice. At your Price Book, select ‘Import Items by CSV’, and click ‘Select File’. Select the file, and click ‘Import’.
If your items were imported successfully, you should see your items on your Price list. Review the list, and click ‘Save’ once you are satisfied.
However, if your items were not imported successfully, click ‘download this CSV’ to download and review the errors. Open the downloaded CSV, and you should see the reason for the import failure. Fix the errors at the original file, and try to import again.