A catalogue can look tidy in a spreadsheet and still be difficult to shop. A customer selects a brass lamp, the photo stays black, and the warehouse gets an order that never specifies the plug. Before choosing a product-page layout, work out exactly what changes when a buyer selects an option.
Suppose the lamp comes in brass or black, each with an EU or UK plug fitted at the factory. There are four possible combinations. If only three are manufactured, prepare three sellable rows. A fourth row marked out of stock suggests an item that might return. A combination that has never existed needs different treatment in the selector.
Ask someone who packs orders to pull the three boxes from the shelf. Can they distinguish them from the label alone? If two boxes have the same description in the catalogue but different plugs inside, marketing has one lamp and fulfilment has two items. Keep one customer-facing product page if that makes shopping easier, but give the order line enough detail for the right box to leave the warehouse.
For each row, record the product family, its own SKU, the finish, the plug type, the price, the stock source and the image. A SKU such as LAMP-BR-EU should still identify the same boxed item after the product name is translated or renamed. If two variants share a photo, reference the same image deliberately. If the finish changes, verify the selected photo shows that finish.
Here is a small import example. All three rows belong to the same lamp. The brass photo can serve both plugs because the image shows the shade and base. The black finish has its own photo. The quantities are sample counts from the warehouse, not values to type into the storefront a second time.
Notice the missing black lamp with a UK plug. A buyer choosing black should see that the UK version is unavailable for this model. A buyer choosing brass may reasonably want a stock notification for the UK version. Decide which choices the page should offer in each case before handing the data to the developer.
A gift message usually belongs to the order. A different factory-fitted plug belongs to the item being picked. Engraving sits between the two: if the workshop engraves a standard lamp after purchase, keep the text with that order line and explain any extra production time. If engraved designs are made and stocked in advance, each stocked version may need its own SKU.
Keep a second eye on returns. When someone orders two identical lamps with different engravings, a single order-level note is ambiguous. Attach each inscription to the right line and check that a reprint of the packing slip keeps the pairing. The customer service team will need that same detail if only one lamp comes back.
See how automated product updates work in the ClassicJPParts store.
Choose one family with an unavailable combination and at least two photos. Switch options on a phone, add a variant to the basket and change its quantity. Compare the description, price and SKU in the basket with the warehouse picking information. Then repeat in a second language. If the shopper and the warehouse can each identify the exact same lamp, you have a pattern worth applying to the rest of the catalogue.
Keep the same SKU for the same physical item. Translate the label the shopper sees. Otherwise a stock update from the warehouse can match the English entry while missing the Latvian or Swedish one.
Photograph the differences a buyer needs to judge. For a lamp that usually means the finish, and perhaps a detail shot of the plug. You can reuse the main image when the visible product is the same. Check that the thumbnail, product page and basket still agree after someone switches colour.
Before cleaning the entire spreadsheet. Import one family, update its stock from the system that owns it and place a test order. A ten-minute discussion about the result can save someone from having to rename hundreds of rows later.