microsyskl Posted February 20, 2006 Posted February 20, 2006 This question is multi faceted... I am new to Shopping Carts. 1) What is the best way to load and maintain the database? Can i populate it in Access and then upload it to the web? 2) Was wondering if I could set up a customer to have their database "live". In other words - they would like to work out of ONE database - on the web. Everyone would be looking at the same thing and the inventory, etc would always reflect accurately. Is this possible with this product . If not, any recommendations? 3) if the above is too difficult, how about nightly synchronizing the two databases and doing a "batch upload" .
seank123 Posted February 20, 2006 Posted February 20, 2006 Assuming you can remotley access the database and it's MySQL, then get the Windows ODBC driver from: http://dev.mysql.com/downloads/connector/odbc/3.51.html Once installed you can access the store database directly from MSAccess (or any other program that uses ODBC data sources). One problem is that OSC uses a number of different tables for the product information - for example model number, price, quantity etc are in the 'products' table, but the products name and description are in the 'products_description' table..... You should be able to come up with a form in Access to handle that though! If you're only wanting to quickly update stock/prices then it's very easy - that's what I do - all our products are listed in a spreadsheet (pricing is based on suppliers prices + a percentage) and stock info is cut/pasted from Sage Accounts - it's then uploaded to the OSC database with Access. For adding neww products I find Mario's oSCommerce Product Manager invaluable: http://www.mariovaldez.net/software/oscpmw...php?v=0.1.2.436
Recommended Posts
Archived
This topic is now archived and is closed to further replies.