'Batch' addition of products?

[willend]

Hello OSC wizards,

 

 

For a specific, existing shop installation that I co-maintain, it would be very handy to be able to add product using e.g. a shell script.

 

I have been looking at the SQL code available through the 'backup' feature to possibly code this up myself. It seems doable,

however not too simple.

 

I have also looked at the "easy populate" ( http://www.oscommerce.com/community/contributions,500 )

which might also work. - However, I find the required unique 'model' tag not too nice as the existing products in the shop _does_not_

have this tag set. Also, the primary maintainer of the shop would likely continue to use the web interface to add products.

 

In principle, what I would prefer is a (php/perl/shell/whatever) *nix script tool to add products using the commandline, in a

way which is directly compatible with adding stuff through the web interface...

 

So: Did anyone write something like this already? (Getting my hopes up) :)

 

 

Cheers,

 

Peter

[Guest]

Hi Peter,

I am looking for this too. I would really like a complete database diagram and the SQL used to add a product. We have been working on a store with 21,000 product that we populated with bash scripts and SQL. The problem is, the person who did most the poplulation is no longer with us.

 

We currently update the products with a shell script from a flat file that the company uploads. We now need to add new products with the same script.

 

Because I need to add this feature right away I'd like to save some time deciphering old code snippets and analyzing. If anyone has this I would certainly appreciate it and I will post what I end up using if not.

 

Best,

-Eric

[willend]

Hi Eric,

 

I guess noone wrote the readymade script we both are looking for....

 

Did you work on the problem since your Feb 14th post? (In any case, a sneak peak at your bash/SQL stuff would probably be really useful.)

 

Cheers,

 

Peter

 

Hi Peter,

I am looking for this too. I would really like a complete database diagram and the SQL used to add a product. We have been working on a store with 21,000 product that we populated with bash scripts and SQL. The problem is, the person who did most the poplulation is no longer with us.

 

We currently update the products with a shell script from a flat file that the company uploads. We now need to add new products with the same script.

 

Because I need to add this feature right away I'd like to save some time deciphering old code snippets and analyzing. If anyone has this I would certainly appreciate it and I will post what I end up using if not.

 

Best,

-Eric

Edited March 19, 2007 by willend