Generate Order Number

[Ninalune]

Order numbers generated by default by OSC are 2, 3, etc. How can I customize it and start, say, from 101?

[Guest]

If you export your orders table from your DataBase using PHPmyadmin you should have something that looks like this

 

-- phpMyAdmin SQL Dump
-- version 2.9.0.2
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Jun 13, 2007 at 11:13 PM
-- Server version: 4.1.21
-- PHP Version: 4.4.2
-- 
-- Database: `your_data_base_name`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `orders`
-- 
DROP TABLE IF EXISTS orders;
CREATE TABLE orders (
 orders_id int NOT NULL auto_increment,
 customers_id int NOT NULL,
 customers_name varchar(64) NOT NULL,
 customers_company varchar(32),
 customers_street_address varchar(64) NOT NULL,
 customers_suburb varchar(32),
 customers_city varchar(32) NOT NULL,
 customers_postcode varchar(10) NOT NULL,
 customers_state varchar(32),
 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,
 delivery_name varchar(64) NOT NULL,
 delivery_company varchar(32),
 delivery_street_address varchar(64) NOT NULL,
 delivery_suburb varchar(32),
 delivery_city varchar(32) NOT NULL,
 delivery_postcode varchar(10) NOT NULL,
 delivery_state varchar(32),
 delivery_country varchar(32) NOT NULL,
 delivery_address_format_id int(5) NOT NULL,
 billing_name varchar(64) NOT NULL,
 billing_company varchar(32),
 billing_street_address varchar(64) NOT NULL,
 billing_suburb varchar(32),
 billing_city varchar(32) NOT NULL,
 billing_postcode varchar(10) NOT NULL,
 billing_state varchar(32),
 billing_country varchar(32) NOT NULL,
 billing_address_format_id int(5) NOT NULL,
 payment_method varchar(32) NOT NULL,
 cc_type varchar(20),
 cc_owner varchar(64),
 cc_number varchar(32),
 cc_expires varchar(4),
 last_modified datetime,
 date_purchased datetime,
 orders_status int(5) NOT NULL,
 orders_date_finished datetime,
 currency char(3),
 currency_value decimal(14,6),
 PRIMARY KEY (orders_id)
);

 

 

At the bottom you want to add just above the );

 

) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=101;

 

 

It would look like

 

 

  PRIMARY KEY (orders_id)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=101;
);

 

 

Then only after BACKING UP FIRST AND MAKING SURE YOUR BACKUP WORKS. You upload that file back up to your DB.

[Guest]

***OR****

 

From PHP MyAdmin you select your osC database. Then click on your Orders table and at the top of the screen you should see something like

 

Server:localhost Database: xxxxxxx Table: Orders

Browse Structure SQL Search Insert Export Import Operations

 

Click on "Operations"....

 

In the Table Options section you can change Auto_Increment to "101" .... then Go or Save.

 

You are done.

 

 

ALWAYS BACK UP FIRST. BETTER SAFE THAN SORRY