How to organize product variants into a consistent table
A variant table helps distinguish the combinations a product actually offers. It is useful when size, color or another option changes the identifier, availability or commercial details.
Start with the right material.
- What you provide
- a product page showing a visible variant matrix.
- The intended result
- Export displayed color, size, SKU and price combinations without guessing hidden stock.
How the workflow works.
Treat each visible combination as its own record and keep its identifier with the corresponding attributes. Do not create combinations merely because individual option names appear elsewhere on the page.
What to check in the result.
Compare the rows with the selected variant information. A displayed option does not establish stock or a particular price for every combination; record only the relationships the source supports.
Import the CSV with a consistent delimiter and inspect text identifiers, dates and amounts before using spreadsheet totals. Keep the original file available while checking any automatic type conversion.
Learn from the worked example.
The downloadable CSV example uses these columns: Color, Size, SKU, Price, Stock. Compare a complete record with the source before sorting, combining or importing your own output.
The supplied example is illustrative. It is not a recorded run on your data.
Download the example ↓Use it with your own material.
- Open the source you want to work with and activate WebAct on that tab.
- Copy the task from the hero, add any required fields or preferences, and review the proposed actions.
- Compare the first result with your source. Ask for a specific correction or refinement where needed.