We're an e-commerce start-up running a magento store, and we need to clear it up a bit, regarding or products catalog. This mission will be in two parts, the second cannot start before the first one is completed.
There we go :
1. Configurable products & SKU's
Our products :
- 8 boxers of different colors, 4 sizes available.
- 8 pairs of socks of different colors, 2 sizes available.
So far, I used "configurable products" to make size selection available.
What I need to do :
- Sets of 2 boxers, in different colors
- Sets of 4 pairs of socks, in different colors
- Sets of 4 boxers, in different colors
- Sets of 1 boxer, 1 pair of socks, in a wooden box
Right now, I'm also using "configurable products" with a SKU for each.
My problem is that my individual boxers or socks & my sets are not linked, so I have to use two different stocks.
But when we prepare the orders, we make sets from individual boxers and socks that we put in a box.
I found a way to do "bundle", but then the client is allowed to choose a size for each of the products in the set. I don't want that. I want the client to select the size once, and order like this.
So I'd like you to configure my sets as a "made of two individual products".
- Red boxers individually
- Blue boxers individually
now I also want to sell
- Set of 1 blue and 1 red boxer.
I want people to select one of these set, and choose the size of it.
Then magento will take away one red boxer AND one blue boxer away from the stocks.
But the client will see it as a set (and the person preparing the order as well)
2. Products views, import & export
Right now I have :
Main store (for french customers only) [url removed, login to view]
> French view, with product description and SEO in french
> English view, with product description not implemented yet (but content waiting in an excel file)
International store (for international customers) > [url removed, login to view]
> English view, nothing implemented yet, but I want the same products than my main store to be available here, with different prices tho.
I know how to export my products,
But I'll need your help to guide me through the creation of a nice Excel file, which will make me able to update all my catalogue on the three views in one time.
Your goal will be to make this Excel clear and ready to import into the Magento system.
10 freelancers are bidding on average $227 for this job
=====Expertness and honesty our goal . we are small team working good quality and accuracy. Ready to start your [url removed, login to view] check [url removed, login to view] you===========