Start a conversation

How to update the quantity pricing

> I would like to know how to update the price to a second price
> group in the database.

create a new csv file with "PRODUCTCODE" or "PRODUCTID" column several "PRICE" columns inside like this:

PRODUCTCODE;PRICE;PRICE;PRICE
SKU123;1:50;20:40;100:30

Which means: if a customer purchases 1-19 items of "SKU123" product, the price will be $50, from 20 to 99 items - $40, over 100 items - $30

If you would like to define wholesale prices for a particular membership, the format will be:

PRODUCTCODE;PRICE;PRICE;PRICE;PRICE
SKU123;1:50;Wholesale:1:45;Wholesale:20:40;Wholesale:100:30

You can use that file in "Inventory update" : "Price" menu.
Do not forget to back your database before any import/mass update operation.
Choose files or drag and drop files
Was this article helpful?
Yes
No
  1. Admin FinestShops

  2. Posted

Comments