Excel Database Spreadsheet

Excel Database spreadsheet

I need to organize a excel database to upload to my e-commerce website.

I have the manufacturer information and I need to create the parent and the child product spreadsheet.

Typical Parent product cell:
CARINA HANDLE LEVER ON ROSE Finish: Satin and Polished Stainless Steel Size: 52 X 8 Sold as: SET Type: SPRUNG and UNSPRUNG Please contact us if you need further information about this product. Sales: 020 xxxx xxxx Free Phone Sales: xxxx xx xx xx Email: sales@xxxx.co.uk

Explanation:
CARINA HANDLE LEVER ON ROSE
Finish: Satin Stainless Steel and Polished Stainless Steel = All finishes available from child products or a different size if this makes the child product unique.
Size: 52 X 8 = extra info
Sold as: SET = extra info
Type: SPRUNG and UNSPRUNG = All types available from the child products
Please contact us if you need further information about this product. = typical info for all products
Sales: xxxxxxx xxx . = typical info for all products
Free Phone Sales: xxxxx xxxxx = typical info for all products
Email: sales@xxx.co.uk = typical info for all products


Typical Child product cell:
CARINA LEVER, SATIN STAINLESS STEEL Finish: Satin Stainless Steel Size: 52 X 8 Sold as: SET Type: SPRUNG Please contact us if you need further information about this product. Sales: xxx xxxx xxxx Free Phone Sales: xxxx xxx xx xx Email: sales@xxxxxx.co.uk


Explanation:

CARINA LEVER ON ROSE , SATIN STAINLESS STEEL = Part of the Name + finish
Finish: Satin Stainless Steel = Just one finish option
Size: 52 X 8 = extra info
Sold as: SET = extra info
Type: SPRUNG = Just one type. If there isn’t info, please leave blank .
Please contact us if you need further information about this product. = typical info for all products
Sales: xxxx xxxx xxx . = typical info for all products
Free Phone Sales: xxxxx xxx xx xx. = typical info for all products
Email: sales@xxxxx.co.uk . = typical info for all products


There will be other column to organize but thy are easy than the above description.

Thanks,

AR