Help me with SKU's and import / export on Magento

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

Current situation

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 :

I have

- 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".

Example :

I'm selling

- 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.

Skills: Excel, Magento, PHP, Product Management, Website Design

See more: wooden design products, wooden box design, website design for import export, set of pairs, seo export, selection problem, ready to use e commerce website, php to excel export, m.s. international, magento import bundle products, how to sell your product design, how to prepare website, how to prepare a website, how to make a product catalog, how to make a catalog of my products, first bit set, e commerce website creation, e commerce how to set up, design socks, choose help, catalog creation, socks box design, products with description, need excel help, how to design a catalogue

About the Employer:
( 28 reviews ) Shanghai, Hong Kong

Project ID: #2520212

Awarded to:


Hello. Magento expert here, ready to start.

$200 USD in 3 days
(15 Reviews)

10 freelancers are bidding on average $227 for this job


Here are Magento Experts , please check Our Latest Magento work and Let me start your work , Thanks

$300 USD in 5 days
(93 Reviews)

=====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===========

$220 USD in 7 days
(128 Reviews)

Veuiller lire mon message. Merci

$150 USD in 3 days
(31 Reviews)

magento/php team

$250 USD in 3 days
(10 Reviews)

Hi, I have 3 years of experience in PHP and following framework and cms I attached my portfolio. i also worked on following technologies 1)Joomla 2)Wordpress 3) Smarty template engine 4) Magento 5) Kohana More

$200 USD in 5 days
(1 Review)

Hello Respected Client, I have Read your requirements and we are very experience in this concept. please check Message Board for more details. Thanks

$200 USD in 5 days
(1 Review)

i want to do work.

$250 USD in 30 days
(0 Reviews)

Greetings! I have gone through your description and would like to work on this project. Regards, SEO INDIA DELHI

$200 USD in 3 days
(0 Reviews)

ready to start asap

$300 USD in 20 days
(0 Reviews)