Jump to content

Archived

This topic is now archived and is closed to further replies.

jimbobsquarepants

Update All Products In Database

Recommended Posts

I work for a mail order company that supply books, from the start of next year book ISBN numbers are changing from 10 to 13 digits. Our product code is a letter say 'M' and then the last 5 digits of the ISBN so ... M12345. That means that when the new ISBN stuff happens that will need to be changed. Also we have the ISBN in the database so that will need to be changed. In the database there are two tables that need their data updating, 'products' needs 'products_model' (the ISBN) updating and 'products_description' needs 'products_code' (you can guess ... our product code) updating.

At the begaining of next year i'll be given a shreadsheet. The website is powered by osCommerce and we have around 24,000 products on there that will need updating at the start of next year  :(

Hope you get what im trying to do lol

So if you guys could point me in the right direction i'd be happy  ;D

Thanks for your time.

Share this post


Link to post
Share on other sites
Well, provided that you update the "products" table, you can update all the related tables accordingly

Share this post


Link to post
Share on other sites
Well, I'm assuming that you have some sort of one-to-one conversion from the existing numbers to the new numbers... if so, simply import these data into a new table, with product_id, oldISBN, newISBN, and then you can issue multi-table updates to take care of the rest.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.