Jump to content
Sign in to follow this  
ddub

Bulk Price Question

Recommended Posts

Cube Cart 6.2.5 windows 10

I am trying to do a bulk price change by category.

I am in the bulk price change tab. 

Bulk price change by category.  Picked my categories

Percentage

I have put a 110% multiplier in (I want a 10 percent price increase)

Nothing is happening.  Cache is also not showing any changes.

What am I doing incorrectly? 

I see noodleman has a app for this, but if it is built in.  Do I need that?

Thank you in advance.

Share this post


Link to post
Share on other sites

Before you make ANY change using a bulk utility, take a database backup. this is in case it goes wrong and you need to rollback the changes. I've seen it happen countless times.. please backup! 

You may not need the module I offer, it's there for a very specific purpose. 

I've not checked into this feature for you as I am pushed for time at the moment, just wanted to share a warning about the backup to potentially save you a headache later. 

 

 

Share this post


Link to post
Share on other sites

"Nothing is happening."

As when you click the Save button? Or, if Save button does submit the form, you do or do not get a fresh page that goes back to listing the products?

 

Share this post


Link to post
Share on other sites

bsmither,

Sorry for the poor explanation, the page refreshes when I hit the save button.  It states that the prices have been adjusted accordingly.  But the cache doesn't highlight and the price does not change.

 

Thank you

Share this post


Link to post
Share on other sites
Posted (edited)

"The price does not change..."

As seen in admin? (Admin does not use the cache, so prices seen here are very fresh, direct from the database - assuming the database did get updated.)

As seen on the storefront? An unlit "Clear Cache" button is interesting.

Edited by bsmither

Share this post


Link to post
Share on other sites

When I am in admin and make any changes.  My cache button on the upper right all turns yellow/orange.

I failed to mention that I am using options.  I think it has to do with that?

Share this post


Link to post
Share on other sites

An orange button is "lit".

Assigning options to products does not affect its base price as seen in admin.

However, on the Bulk Price Change screen, the admin can select what is essentially all possible price determinants.

I am running tests.

Share this post


Link to post
Share on other sites

I have found several errors in the admin file /sources/products.assign.inc.php, but this change should be the actual fix:

Near line 42, find:

} elseif(ctype_digit($_POST['category'])) {
    if ($category_products = $GLOBALS['db']->select('CubeCart_category_index', array('DISTINCT' => 'product_id'), array('cat_id' => (int)$_POST['category']))) {

Change to:

} elseif (ctype_digit($_POST['category']) || array_map('ctype_digit', $_POST['category'])) {
    if ($category_products = $GLOBALS['db']->select('CubeCart_category_index', array('DISTINCT' => 'product_id'), array('cat_id' => /* #2328 (int) */ $_POST['category']))) {

 

Share this post


Link to post
Share on other sites

bsmither,

this will work on pricing when it is done through options?  Thank you.

Share this post


Link to post
Share on other sites

If the choice of what to apply the change to includes the product options, then prices for the targeted products found referenced in the database table CubeCart_option_assign will be changed. This is the standard CubeCart table that holds the price (and weight) differentials and absolutes.

There will be no changes made elsewhere that are controlled by any plugins that affect the behavior of option pricing.

Share this post


Link to post
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.

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

Sign in to follow this  

×
×
  • Create New...