A question for shop owners with many products

[shaytaan]

Hello all shop owners,

 

I've just started my my little firm (Hardware store :) )

 

I interted the products using easypopulate (about 2000 products :-" ) (I copy and paste every single product and seached/found some product picture/product data/ product info for it (one months hard work :( ) )

 

I receive the pricelist from my vendor in a excel file witch har product price, product name and model nr. And this excel file har 50000 products :o

 

Now, how do I update those 2000 products from 50000 excel file? How do you guys do it?

 

 

Any advices need very badly :blush:

[Guest]

Hello all shop owners,

 

I've just started my my little firm (Hardware store :) )

 

I interted the products using easypopulate (about 2000 products :-" ) (I copy and paste every single product and seached/found some product picture/product data/ product info for it (one months hard work :( ) )

 

I receive the pricelist from my vendor in a excel file witch har product price, product name and model nr. And this excel file har 50000 products :o

 

Now, how do I update those 2000 products from 50000 excel file? How do you guys do it?

Any advices need very badly :blush:

 

 

I am glad you posted this question because I also have the same exact situation. My supplier does the same thing. They send me one huge excel file with all of the prices and quantity. By the time I am done manually updating the prices, it is time to do it again. I feel your pain.

 

P.S. Maybe you want to trade sources?:)?:)

[seank123]

Here's how I do it.

 

Download this:

 

http://www.mysql.com/products/connector/

 

It's a ODBC connector for MS Acess, Excel etc to allow them to acces the MySQL database directly.

 

I then use Acess to grab the 'products' database table. This has the OSC product ID, model, price etc in it.

 

If you just cut/paste the columns you need (product ID and model should do it) into a spreadsheet, you can then use lookup tables to grab the prices from the vendor sheet - you will need to mactch the OSC prduct ID with the vendor ID as they're probably different (unless you use their model number as the 'model' in OSC) - you will be able to use a lookup table to match the model to the price and then just cut/paste the price column back to the database.

 

It's a pain to set up, but once done, you can update the prices in a matter of minutes.

[shaytaan]

Here's how I do it.

 

Download this:

 

http://www.mysql.com/products/connector/

 

It's a ODBC connector for MS Acess, Excel etc to allow them to acces the MySQL database directly.

 

I then use Acess to grab the 'products' database table. This has the OSC product ID, model, price etc in it.

 

If you just cut/paste the columns you need (product ID and model should do it) into a spreadsheet, you can then use lookup tables to grab the prices from the vendor sheet - you will need to mactch the OSC prduct ID with the vendor ID as they're probably different (unless you use their model number as the 'model' in OSC) - you will be able to use a lookup table to match the model to the price and then just cut/paste the price column back to the database.

 

It's a pain to set up, but once done, you can update the prices in a matter of minutes.

 

 

Thanks for replying,

 

 

I download the ODBC connector and installed it.

I started MS Access and what should I do next? I don't know how to use MS Access :blush:

 

Please describe step by step if it's possible, I'm a noob and please shoot me at the head :blush:

May I ask for the MS Access file that you have :D

 

Thanks again

[shaytaan]

Anyone else? :-"

[shaytaan]

Is there a big secret in this? Why no one is replying :blush:

[tonspr]

Yes, I would too like to know what to do at this step. I downloaded it and installed it and I'm stuck there.