Smack Digital Inc.

Increase Your X-Cart Orderid Value

Posted by and last updated Apr 23, 2014 11:16 AM

Increase your X-Cart orderid value so customers won't know how many orders you've actually received.

By default, X-Cart will begin counting orders at 1 and increase with each attempted order. You can manually set this to any value you wish with the mysql statement below.

Log into your X-Cart admin section and access the "Patch/Upgrade" section from the "Tools" menu.

Scroll down the page to the "Apply SQL patch" section and apply the following patch:

ALTER TABLE xcart_orders AUTO_INCREMENT = 25000;

The section in which to apply will look as follows:

Apply X-Cart SQL Patch

About the Author

Jonathan Peters Jonathan's founder of Smack Digital, a digital strategy agency that creates and executes online business success for executives who are highly motivated to quickly increase their market share. With more than two decades of experience on the web for clients ranging from non-profits to billion dollar enterprises, Jonathan's an expert in web development, eCommerce, software programming, search engine optimization and social media marketing.

Browse By Category

RSS Feeds

Don't miss out! Subscribe to our RSS Feeds to receive instant notification when new entries are added.

RSS Feed for All Categories
RSS Feed for X-Cart Code Snippets
We choose our clients selectively.
Let's talk success. Apply to work with us.
Apply toWork With Us
Apply toWork With Us