- użytkownik eksportuje produkty z db do excel
- edytuje plik
- importuje do bazy
Ale:
- produkty w bazie mają wariacje.
- tzn.: produkt ogórki w tabeli PRODUCT ma product_id==1, ale w tabeli PRODUCT_VARIATION te ogórki o product_id==1 mogą być w opakowaniach 100g, 300g, 500g i każdy ma inne SKU.
Kod
+-------------------+
| PRODUCT |
+-------------------+
| id | product_name |
+----+--------------+
| 1 | ogórki |
+----+--------------+
| 2 | fasola |
+----+--------------+
| 3 | rzodkiew |
+----+--------------+
| 4 | arbuz |
+----+--------------+
| PRODUCT |
+-------------------+
| id | product_name |
+----+--------------+
| 1 | ogórki |
+----+--------------+
| 2 | fasola |
+----+--------------+
| 3 | rzodkiew |
+----+--------------+
| 4 | arbuz |
+----+--------------+
Kod
+-------------------------------+
| PRODUCT_VARIATION |
+-------------------------------+
| id | product_id | sku | price |
+----+------------+-----+-------+
| 1 | 1 | 89 | 2,00 |
+----+------------+-----+-------+
| 2 | 1 | 90 | 3,00 |
+----+------------+-----+-------+
| 3 | 1 | 91 | 5,00 |
+----+------------+-----+-------+
| 4 | 2 | 99 | 4,00 |
+----+------------+-----+-------+
| PRODUCT_VARIATION |
+-------------------------------+
| id | product_id | sku | price |
+----+------------+-----+-------+
| 1 | 1 | 89 | 2,00 |
+----+------------+-----+-------+
| 2 | 1 | 90 | 3,00 |
+----+------------+-----+-------+
| 3 | 1 | 91 | 5,00 |
+----+------------+-----+-------+
| 4 | 2 | 99 | 4,00 |
+----+------------+-----+-------+
Jak odwzorować taką relację w excel?