My Sellerdeck Account | Free Trial

Sellerdeck Community & Knowledge Base

Old 20-Sep-2017, 08:37 AM
hazelann hazelann is offline
Registered User
Join Date: Sep 2013
Full Name: Hazel McLaughlin
Posts: 4
Thanks: 1
Thanked 0 Times in 0 Posts
Quantity Based Pricing

How do I enter Quantity Based Pricing for individual products available for all customers into a Hierarchical Spreadsheet as I have over 5000 products and would take a long time to do them all individually

I have a database from which I produce the Hierarchical export - but it wont import the retail prices
Reply With Quote
Old 20-Sep-2017, 09:42 AM
NormanRouxel's Avatar
NormanRouxel NormanRouxel is offline
Registered User
Join Date: Dec 2002
Full Name: Norman Rouxel
Posts: 10,809
Thanks: 9
Thanked 763 Times in 637 Posts
Here's an example of a minimal file that updates a product. It's for the demo site where the Three Diamond Ring usually has a single price of 20. Now we'll create a minimal import file to set quantity 5 to 17.50 and quantity 10 to 15.
Import with "Update" selected and that's the job done.
Header:Product,Product Reference,Short Description
Header:Price,Customer Group,Price,Generated,Can be Ordered,Product Visible,Minimum,Customer Message,IsDeleted
Product,"1","Three Diamond Ring"
Note that the price is in pennies.

Best test on a spare system before committing it to a live site.
Norman -
Edinburgh, U K / Bitez, Turkey
Reply With Quote
The Following User Says Thank You to NormanRouxel For This Useful Post:
hazelann (21-Sep-2017)

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

All times are GMT. The time now is 03:40 PM.

Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.