Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Quantity Price Breaks... help?


weofui

Recommended Posts

What the heck did I do wrong...

 

I'm getting this message when I log into the Admin/Catalog section:

 

 

1146 - Table '[iD].products_to_discount_categories' doesn't exist

 

select p.products_id, pd.products_name, p.products_quantity, p.products_image, p.products_price, p.products_qty_blocks, p.products_date_added, p.products_last_modified, p.products_date_available, p.products_status, ptdc.discount_categories_id, dc.discount_categories_name from products p left join products_to_discount_categories ptdc on p.products_id = ptdc.products_id left join discount_categories dc using(discount_categories_id), products_description pd, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = '0' order by pd.products_name

 

[TEP STOP]

 

 

I'm admittedly a newbie at all of this, so chances are good I've mucked something up. Any thoughts?

 

 

t

Link to comment
Share on other sites

What the heck did I do wrong...

 

I'm getting this message when I log into the Admin/Catalog section:

1146 - Table '[iD].products_to_discount_categories' doesn't exist

Did you ran the sql file price_break.sql in phpMyAdmin (or whatever tool you have available to make changes to your database) before adding this contribution?

The QPBPP thread is here by the way.

Link to comment
Share on other sites

  • 2 weeks later...

Hello all

 

I installed the qpbpp contrib together with STS. Within the admin I can set the values for block quantity and the price-quantity-steps.

 

But there are faults when the pricing is calculated. The price is different from the one I wanted to have.

 

Furthermore as a client I can't see the pricing in the catalog sector.

 

Is there anybody who can help me fixing this?

 

Thank you very much in advance

 

Sunny

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...