I need a script, which, when ran, will export data from the OS Commerce DB into a tab delimited .csv file which will do the following:
OSC Categories and Subcategories each have an ID number, which defines where the product is located. We are going to issue NEW id numbers, to be used with another product, thus the script should ask, what numbering sequence it should begin with.
OS Commerce Parent Cat: Memory Cards - ID # 1
OS Commerce SubPar Cat: For Dell - ID # 100
Those would be the OS Cat ID Numbers - We would want to change those numbers, based on the number we tell it to start at, and also, automatically change it for each product.
I have included a base script, which will get the product data and info needed... and will give the cat NAME ... I need it to give me the Cat ID number AND the -NEW- cat ID number.