Eyewear Product CSV Preparation

Job ID: 40268202

Budget: $30 – $250 USD

I need a clean, fully-formatted CSV that I can import straight into my ecommerce backend for a new range of eyewear—glasses and sunglasses. The file has to capture every product and its variants so that the catalogue appears exactly as intended the moment I upload it.

Here’s what must be present:

• Core fields: product name, unique SKU, price, image, colour, lens colour, material
• Variant columns: colour, lens colour, and size, with parent/child relationships set correctly so each option displays in the dropdown menu online

For each model, you’ll organise the data so the main (parent) item holds the shared information while each variant row carries only what differs. Images need to map to the right variant wherever colour or lens colour changes.

I will supply product information, pricing, and image folders; you transform that into a ready-to-upload CSV, check for consistency, and flag any missing assets. Before delivery, please test-import on a blank storefront or validator to confirm there are no format errors.

Deliverable: one import-ready CSV and a brief note outlining the column structure you used, so I can maintain it going forward.