Update multiple price lists via CSV

To update multiple price lists via CSV, you must have already created the price list in your TradeGecko account. To create a new price list, Settings> Price Lists> New Price List. For more information about creating new Price Lists, click here. Once you have done that, you will be able to update the prices of all your products across multiple price lists using the CSV.

How to:

In this example, we will update the prices for Cat Ties. From our inventory section, we can see in the variant details that there are two prices (Sales and Premium) left blank.  

Screen_Shot_2017-03-28_at_10.43.51.png

Now, let’s update the Sale and Premium prices for Cat Ties (all variants).

1. Go to Inventory> Update existing products. Download Your Products Spreadsheet. 


Screen_Shot_2017-03-28_at_10.44.00.png

2. You will see the columns for “Sale [AUD]” and “Premium [AUD]”. Add your prices in the respective columns. 


Screen_Shot_2017-03-28_at_10.45.44.png

3. Once you are done editing, upload the file on TradeGecko. 


Screen_Shot_2017-03-28_at_10.44.08.png

TradeGecko is updating your products now.

Screen_Shot_2017-03-28_at_10.44.36.png

Done!

Screen_Shot_2017-03-28_at_10.44.39.png

Now refresh your inventory to see the updates.

Screen_Shot_2017-03-28_at_10.44.52.png

In Inventory> Variant> Details, you can view your updated price lists. 

Screen_Shot_2017-03-28_at_10.45.20.png

Can I import new products with new custom price lists using the product template?

No, you cannot create new products with new custom price lists at the same time. You have to first create the price list from your account settings and when you import new products, the custom price lists will appear as additional columns after all the product information. For more information about importing products via csv, click here. 

How are the CSV columns for price lists structured?

The currency columns follow the structure "price_list_name (price_break)[currency]" so the Sale price list in AUD is depicted as “Sale [AUD]”.

 

Print Friendly Version of this pagePrint Get a PDF version of this webpagePDF
Have more questions? Submit a request
Was this article helpful?
0 out of 0 found this helpful

Comments

NEW TO TRADEGECKO? START A 14 DAY FREE TRIAL, NO CREDIT CARD REQUIRED