Hello. Sorry by my english, I'm latin american. I have a method to download the file named en_products.php to edit it and then upload again. It's because I have more than thousand products.
I can edit the name, price, status, position and availability in this file. But I want to edit the category too. How can I do that the category appears in the file en_products.php?
it doesn't work as you think. Category-product tie comes from different file (en_products_pages.php). Check the QC db structure here: http://opensolution.org/download/Quick.Cart/other/v3.x_db.png
if you are interested, I have an awesome CVS import/convert php script that my brother periodically uses to upload about 4000 products to his website. I can share it for some beer money. Work with it is very quick and it even has a bit more capabilities than the import in the QC EXT version (which I also recommend, btw).
My converter is 100% custom work, various columns in your Excel file really don't matter, the script will be accustomed to your format. It also removes 'old' products/prices/descriptions and replaces them with 'new' products. This is a superb feature for periodical updating of your webshop.
If you however need to upload/convert your products just once, do let me know, as only some Excel work is needed for that, I think. I've helped a client with something like this before. It does take some excel skills though.
¿comprendes, amigo?
juancile
2009-07-31 00:48
Hello Beholder!. Yes, I am interested. Can you send me this CVS?.
I have to change the products price once a month, and I don't want to change one for one.
I have a formula in excel that allows me to change the products price to a complete category...
