Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

"Updating" product info - relative MySQL tables


jhande

Recommended Posts

Posted

I just want to make sure that I am not missing something.

 

When changing information pertaining to exsisting products "without" attributes, exactly what tables get modified?

 

From what I can see:

products

products_description

 

When adding "new" products to exsisting categories and manufacturers without attributes what tables get modified?

 

From what I can see:

products

products_description

products_to_categories

 

The reason for this is that I want to UPDATE/INSERT "just" the tables from one database to another using phpMyAdmin.

 

I'm using my offline/localhost version to add/edit products and it just takes too long replacing the entire database online.

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Posted

Nothing? ohmy.gif

 

Nobody? sad.gif

 

Guess I'll give my hunch a try and see if anything breaks.

 

 

 

Sure, why not Jim. I believe that's all the tables that get changed.

Ok, thanks, I will try it then.

whistling.gif

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Posted

yes, those are the tables, the only issue is that products_id get generated when inserting, you have to be sure that your databases are absolutely in sync with these ids.

KEEP CALM AND CARRY ON

I do not use the responsive bootstrap version since i coded my responsive version earlier, but i have bought every 28d of code package to support burts effort and keep this forum alive (albeit more like on life support).

So if you are still here ? What are you waiting for ?!

 

Find the most frequent unique errors to fix:

grep "PHP" php_error_log.txt | sed "s/^.* PHP/PHP/g" |grep "line" |sort | uniq -c | sort -r > counterrors.txt

Posted

Thank you!

 

thumbsup.gif

- :: Jim :: -

- My Toolbox ~ Adobe Web Bundle, XAMPP & WinMerge | Install ~ osC v2.3.3.4 -

Archived

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

×
×
  • Create New...