My SellerDeck Account | Newsletter | Free Trial

Community and Knowledge Base

  #1  
Old 20-Sep-2017, 08:37 AM
hazelann hazelann is offline
Registered User
Join Date: Sep 2013
Full Name: Hazel McLaughlin
Posts: 3
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
  #2  
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,752
Thanks: 9
Thanked 734 Times in 617 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.
Code:
Version:16
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"
Price,Retail,1750,0,1,1,"5","",0
Price,Retail,1000,0,1,1,"10","",0
Note that the price is in pennies.

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


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 02:15 PM.


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