Jump to content


Ed Newman

Member Since 02 Mar 2013
Offline Last Active Apr 12 2021 06:12 PM

Topics I've Started

Order Status Change Increasing Product Quantity

07 April 2021 - 12:51 PM

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. 

Cs Cart 4.3.6 And Mysql 8

01 February 2021 - 06:31 PM

Migrating to a new webserver and based on the documentation not showing there would be any issues, I installed MySQL 8.0.23  But now I am getting an error in admin, manage products because one of the select statements uses 'groups' which is now a restricted keyword.  Anyone know of a simple solution to have MySQL run in some sort of a compatible mode?


SELECT COUNT(DISTINCT pf.feature_id) FROM cscart_product_features AS pf LEFT JOIN cscart_product_features AS groups ON pf.parent_id = groups.feature_id LEFT JOIN cscart_product_features_descriptions ON cscart_product_features_descriptions.feature_id = pf.feature_id AND cscart_product_features_descriptions.lang_code = 'en' WHERE 1 AND pf.feature_type != 'G' AND pf.feature_id NOT IN (0, 1, 3, 4, 5, 6, 7, 8, 9, 10, 11, 13, 17, 22, 24)

Limit Character Types In Profile Fields - I.e. First And Last Name

20 April 2020 - 01:08 PM

Getting a lot of spam in new customer profiles.  People are entering urls in the first or last name.  Get a loan, cryptocurrency, whatever crap.  I'd like to restrict the data entry in the first and last name field to only A-Z characters.  Any easy way to do this?  Anyone have an add-in or want to write one for a reasonable amount of money?