Jump to content

Sale Pricing SQL commands

Brian Verboom

Recommended Posts

Can someone create the sql command to create sale prices from retail x 0.8   (for a sale price = 80% or retail)  where cat id =  x

I want to run it a few times for different categories, creating sale prices by category, at a percentage of my retail pricing

And why when i select to view sale items (sale set globally in admin) I only see the two items that have sale prices set, yet in the side bar all items show up with the global discount applied.....all items are getting marked down, but the only ones that show up with pictures when I click "Sale Items" are the two I have already set up with sale prices.



Link to comment
Share on other sites

This would be similar to what you want to do:


Pricing Quantity changing SALE price to 80% of PRICE.
UPDATE `CubeCart_inventory` SET `sale_price` = (`price` *.8) WHERE `price` > 18.00 AND `stock_level` > 0;

Of course the stuff after WHERE would have to be changed to the category id.

Link to comment
Share on other sites

UPDATE `CubeCart_inventory` SET `sale_price` = `price` * 0.8 WHERE `cat_id` = "x";

Be sure to prepend a table prefix if appropriate.

In admin, Store Settings, Features tab, there is "Number of sale items to display". Confirm this value.


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.

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