Price List Details
Below are helpful details and information about the price list export:
🤓Tip: For a video on updating a price list using the export function, register for our webinar on price list and product management.
You can update the pricing, VAT rate and your internal SKU code. The SKU / stock code is located in Column Q.
The VAT rate from the price list export overrides the standard VAT rate set when creating the product, as it can be modified for each customer individually.
If you've exported a general price list for without selecting one customer, the List prices are in column Z.
If you've exported the price lists for multiple customers, the first price list is in column AB, the VAT rate is on the second column after, and every fourth column after AB is the next price list.
To offer a product to a customer, add a price in their Price List column: example AB.
Within Manage Price Lists the floppy disk icon to the right of the customers price list will export only the products the customer has access to purchase and can be used to update the SKU or price in the same way as the export detailed below.
The price list export may not export immediately, if this is the case you will be notified and the export will be emailed to you once it has been completed.
Use the export to update your price list
To update your price list using the export, follow the steps below:
📌Note: you cannot create products using a Price List import. To add new products, please refer to single product creation and batch product creation.
Click Price Lists, then click Export Price Lists.
Select which price lists to export, then click Export Price Lists.
Leave Step 2 as Products configured with a supplier code.
Click Complete Export.
Update the amendable cells, pricing, VAT rate and / or SKU code and save the file
Click Import Price Lists.
Select your Live Date and Live Time.
For changes to apply immediately, leave the default date and time.
Select your file, then click Complete Import.
Update price or SKU per product
To update a price or SKU for a single product at a time, follow the steps below:
On the home page, in Product Locator enter the PID, SKU, or a keyword.
Click Go.
If more than one product fits the description, select the View Settings icon by the correct item.
If needed, edit the SKU and click Save Changes
Click the Pricing tab and enter price in Net Column.
Click Save Prices.
An alert sends to the customer for approval.
Ireland suppliers only
The deposit return scheme (DRS) charge can be added to existing products via the export by adding the DRS SKU code to column X, saving the file and importing it back into the system.