Looking through the screencast, Shannon says that all database attributes are available for import and export. However cross sells and upsells aren’t an attribute in the database, and as far as I can work out won’t be an option for import & export. Is this correct, and if so, is it possible to add in columns for cross-sell and upsell and give SKUs of associated products? It would be really useful to be able to update these in bulk too.
For anyone else struggling with this issue – I used a work-around that may work for some people.
I am setting up a website with more than 10,000 products. We sell light fixtures and many of them come in different finishes (colors). I need a link on each fixture to the other same.
Because configurable products are such a mess for us to deal with importing, we decided to take each different finish and make it a related product – which works well since each fixture with a different finish actually has a different model number.
However, I can not find a way to import related products using data flow, so we defaulted to creating HTML tags in the description for each product, linking customers to the related product. I wrote some script in excel that was able to do this for us.
Just FYI, in 1.1 the product relationships are easy to setup via the web service API. I currently have an issue where my cross sells don’t show up (whether added manually via the GUI, or via the API so I do not believe it is API related) but otherwise works great.
Just FYI, in 1.1 the product relationships are easy to setup via the web service API. I currently have an issue where my cross sells don’t show up (whether added manually via the GUI, or via the API so I do not believe it is API related) but otherwise works great.
How do you set this up? Do you have to know which tables to update?
I have a bunch of products that I need to relate and associate. I’d really like to see the mass action on the product grid for all the relationships (related, cross-sell, up-sell, and associated).
Still no news regarding this? Soon 1 year from the first post.
It should not be that much complicated to improve the import parser so that it can process “related products”, “cross-sells” and “up-sells” fields.
It’s not efficient to use the API just for that (the current import parser “Import All products) is fine for everything else, even if I had to hack it to handle better images and multi stores).
How do you set this up? Do you have to know which tables to update?
I have a bunch of products that I need to relate and associate. I’d really like to see the mass action on the product grid for all the relationships (related, cross-sell, up-sell, and associated).
Sorry I never replied to this before. The API features that are implemented (some features are still missing) are pretty well documented and there is example code to get you started.
But loading this way is rather slow and I agree we need a better native bulk loading solution - especially if they hope to get people with existing sites to switch over to magento.
I have 16500 “simple products”, not “configurable products”, that I’ve imported, and would surely love to know how to add related/cross-sell/up-sell products to each of my existing products, without having to go through the tedious minimum 4-step process of manually changing each product, one at a time, in Magento.
Has anyone been able to accomplish this yet? I would surely appreciate the help.
It would have really been nice if one could select multiple simple products at one time in the admin panel, just like updating attributes, and assign the same related/cross-sell/up-sell products to a selected group of existing products. Same with a new product, that would go great with about 50 other existing products.
Sales: Call 877.832.5289 (N America)|310.295.4144 (International)
