Jump to content

  • You cannot start a new topic
  • You cannot reply to this topic

Order Status Change Increasing Product Quantity Rate Topic   - - - - -

 
  • Ed Newman
  • Advanced Member
  • Members
  • Join Date: 02-Mar 13
  • 140 posts

Posted 07 April 2021 - 12:51 PM #1

Here is my headache.  Took me a while to debug it to here, but now I am stumped.  Person places an order for an item we manufacturer.  Order status changes to PAID and the inventory is decreased.  Great, working as planned.  Now if we have it in stock packaged, we change to preparing for shipment and shipped, quantity stays reduced.  Working as planned.  My problem is we created an additional status called PARTS, which is for items that are conceptually on backorder or at least not packaged.  When we change the status from PAID to PARTS, it increases the quantity of the product in the system.  The order status identified for PARTS status is T in case it ends up being relevant.  Now I know in order status, there is an option to increase or decrease inventory.  I checked and it was indeed set to decrease.  I changed it to increase, saved then back to decreased and saved just to make sure.  No effect.  Verified in the database is it stored as 'D' for decrease.  Still not working.  It always increases the product quantity and then decreases is when I change back to paid.  Any idea if there is code somewhere else in here, maybe that relates to the 'T' status as something else that would normally increase it?  Thanks for any help or ideas. 


Ed Newman
Dark Storm Industries LLC
www.dark-storm.com


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21708 posts

Posted 07 April 2021 - 02:26 PM #2

Try to change it directly in database to 'I'


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • Ed Newman
  • Advanced Member
  • Members
  • Join Date: 02-Mar 13
  • 140 posts

Posted 07 April 2021 - 08:09 PM #3

Try to change it directly in database to 'I'

 

Only other available letter is 'N' which I know is hardcoded for incomplete.  All of the other A-Z are taken.


Ed Newman
Dark Storm Industries LLC
www.dark-storm.com


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21708 posts

Posted 08 April 2021 - 07:52 AM #4

I do not mean the order status letter, but value of the "inventory" column


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)

 
  • Ed Newman
  • Advanced Member
  • Members
  • Join Date: 02-Mar 13
  • 140 posts

Posted 08 April 2021 - 04:10 PM #5

I do not mean the order status letter, but value of the "inventory" column

 

No change regardless of whether that value is D or I, inventory increases with both on a status change.


Ed Newman
Dark Storm Industries LLC
www.dark-storm.com


 
  • eComLabs
  • CS-Cart Expert
  • Authorized Reseller
  • Join Date: 27-Jan 14
  • 21708 posts

Posted 09 April 2021 - 05:40 AM #6

It is strange. Did you clear cache after direct changes in the database?


GET A FREE QUOTE | CS-Cart Add-ons | CS-Cart Licenses | CS-Cart Development | CS-Cart Design | Server Configuration | UniTheme and YOUPI
CS-Cart                USD 345     Multi-Vendor              USD 1250    Multi-Vendor PLUS           USD 3100 (2775)
CS-Cart Ultimate  USD 775     CS-Cart + YOUPI      USD 545      Multi-Vendor Ultimate       USD 7500 (6000)