Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Quantity Price Breaks and Bulk Product Import


trishaw

Recommended Posts

I have the quantity price breaks contribution installed and working well. I have loaded a file of 5000 products into the products table, the products_description table and the products_to_categories tables using insert into statements and everything still working. However I am at a loss at how to get my price breaks imported. My file has products_id followed by ten quantity and price breaks so like this:

 

products_id, price1, quantity1, price2, quantity2, price3, quantity3, price4, quantity4, etc.

 

sample data would be

3, 10.00, 1, 9.50, 5, 8.50, 10, 7.50, 20 etc.

 

I need to get these into the products_price_break table so they need to be like this:

 

products_id, products_price, products_quantity

3, 10.00, 1

3, 9.50, 5

3, 8.50, 10

3, 7.50, 20

 

Anybody have any ideas on how to do this? Any suggestions are greatly appreciated!

Link to comment
Share on other sites

you need to modify the Bulk Product Import module to get the Quantity Price Breaks import too.

Please read this line: Do you want to find all the answers to your questions? click here. As for contribution database it's located here!

8 people out of 10 don't bother to read installation manuals. I can recommend: if you can't read the installation manual, don't bother to install any contribution yourself.

Before installing contribution or editing/updating/deleting any files, do the full backup, it will save to you & everyone here on the forum time to fix your issues.

Any issues with oscommerce, I am here to help you.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...