willend Posted February 13, 2007 Share Posted February 13, 2007 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 Quote Link to comment Share on other sites More sharing options...
Guest Posted February 14, 2007 Share Posted February 14, 2007 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 Quote Link to comment Share on other sites More sharing options...
willend Posted March 19, 2007 Author Share Posted March 19, 2007 (edited) 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 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.