change default order number system

[Rod1mu5]

Morning,

Im trying to figure out how to change the default order number system. I have 2 OSCMax carts going to a single paypal checkout and I believe the duplicate order numbers are causing paypal to reject orders.

Is there away to go and hack the 'order #' so that say store 1 starts with e0100 and store 2 starts with f0100 so that they are different to paypal?

I saw a thread opened on this but no answer was provided....Thanks in advanced

[MindTwist]

Doing that would probably mean touching too much code.

I would just "manually" raise the order number on one of your stores so they are way off related to the other one. Like, one store starts invoicing at number 1, the other one starts at number 10000.

[Rod1mu5]

Thats sounds like a plan...where is this accomplished from. Where can i mod that from? I don't see anywhere in the admin panel where i can set that?

Thanks.

[MindTwist]

Easiest way I can think of, export with phpmyadmin your database, or just your table 'orders'. It will look like something like this:

-- 
-- Estructura de tabla para la tabla `orders`
-- 

DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
  `orders_id` int(11) NOT NULL auto_increment,
  `customers_id` int(11) NOT NULL default '0',
  `customers_name` varchar(64) NOT NULL,
  `customers_company` varchar(32) default NULL,
  `customers_street_address` varchar(64) NOT NULL,
  `customers_suburb` varchar(32) default NULL,
  `customers_city` varchar(32) NOT NULL,
  `customers_postcode` varchar(10) NOT NULL,
  `customers_state` varchar(32) default NULL,
  `customers_country` varchar(32) NOT NULL,
  `customers_telephone` varchar(32) NOT NULL,
  `customers_email_address` varchar(96) NOT NULL,
  `customers_address_format_id` int(5) NOT NULL default '0',
  `delivery_name` varchar(64) NOT NULL,
  `delivery_company` varchar(32) default NULL,
  `delivery_street_address` varchar(64) NOT NULL,
  `delivery_suburb` varchar(32) default NULL,
  `delivery_city` varchar(32) NOT NULL,
  `delivery_postcode` varchar(10) NOT NULL,
  `delivery_state` varchar(32) default NULL,
  `delivery_country` varchar(32) NOT NULL,
  `delivery_address_format_id` int(5) NOT NULL default '0',
  `billing_name` varchar(64) NOT NULL,
  `billing_company` varchar(32) default NULL,
  `billing_company_tax_id` varchar(32) default NULL,
  `billing_street_address` varchar(64) NOT NULL,
  `billing_suburb` varchar(32) default NULL,
  `billing_city` varchar(32) NOT NULL,
  `billing_postcode` varchar(10) NOT NULL,
  `billing_state` varchar(32) default NULL,
  `billing_country` varchar(32) NOT NULL,
  `billing_address_format_id` int(5) NOT NULL default '0',
  `payment_method` varchar(32) NOT NULL,
  `cc_type` varchar(20) default NULL,
  `cc_owner` varchar(64) default NULL,
  `cc_number` varchar(32) default NULL,
  `cc_expires` varchar(4) default NULL,
  `last_modified` datetime default NULL,
  `date_purchased` datetime default NULL,
  `orders_status` int(5) NOT NULL default '0',
  `orders_date_finished` datetime default NULL,
  `currency` char(3) default NULL,
  `currency_value` decimal(14,6) default NULL,
  `paypal_ipn_id` int(11) NOT NULL default '0',
  `fedex_tracking` varchar(20) NOT NULL,
  `purchased_without_account` tinyint(1) unsigned NOT NULL default '0',
  `shipping_tax` decimal(7,4) NOT NULL default '0.0000',
  `customer_ip_address` varchar(15) default NULL,
  PRIMARY KEY  (`orders_id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=672 ;

-- 
-- Volcar la base de datos para la tabla `orders`
-- 

INSERT INTO `orders` (`orders_id`, `customers_id`, `customers_name`, `customers_company`, `customers_street_address`, `customers_suburb`, `customers_city`, `customers_postcode`, `customers_state`, `customers_country`, `customers_telephone`, `customers_email_address`, `customers_address_format_id`, `delivery_name`, `delivery_company`, `delivery_street_address`, `delivery_suburb`, `delivery_city`, `delivery_postcode`, `delivery_state`, `delivery_country`, `delivery_address_format_id`, `billing_name`, `billing_company`, `billing_company_tax_id`, `billing_street_address`, `billing_suburb`, `billing_city`, `billing_postcode`, `billing_state`, `billing_country`, `billing_address_format_id`, `payment_method`, `cc_type`, `cc_owner`, `cc_number`, `cc_expires`, `last_modified`, `date_purchased`, `orders_status`, `orders_date_finished`, `currency`, `currency_value`, `paypal_ipn_id`, `fedex_tracking`, `purchased_without_account`, `shipping_tax`, `customer_ip_address`) VALUES 
...
bla bla bla

This is what my table looks like, notice the "AUTO_INCREMENT=672". That means that my last order was 671, and next one will be 672. Change that to 10001, reimport the table with phpmyadmin (it will drop the table, create it again, import your data), and the next order you have on that store will be number 10001.

[Rod1mu5]

thanks....trying that now...