Import Bundles
How to Access
"Products" → "Bundles" → "Import"
Contents
1. Use Cases
Quick Links: Batch Create Gift Boxes | Update Contents | System Migration | Seasonal Limited
Scenario 1: Batch Create Holiday Gift Boxes
Situation: Sales says we need 50 gift boxes for the holidays, each with different product combinations.
How to do it:
▸ Download and Fill Template
- Click "Import" → "Download Template"
- Fill in each gift box's name, SKU, and component products in Excel
- One gift box with multiple products takes multiple rows
▸ Upload and Import
- Upload file, don't check "Override existing data"
- Click "Upload"
Result: Go to "Data Management" → "Import List" to check processing results.
Scenario 2: Update Gift Box Contents
Situation: 10 gift box bundles need to swap "Brand A cookies" with "Brand B cookies".
How to do it:
▸ Export Existing Data
- First export these 10 bundles from the bundle list
▸ Modify and Import
- Change the product SKUs in Excel
- Upload file, check "Override existing data"
- Click "Upload"
Result: Go to "Data Management" → "Import List" to verify update results.
Scenario 3: Migrate Bundle Data from Old System
Situation: Old system has 200 bundles that need to move to the new system.
How to do it:
▸ Prepare Data
- Export data from old system
- Format according to template (SKU, product SKU columns must match)
- Make sure component products already exist (products in bundles must exist first)
▸ Import in Batches
- Import in batches, recommend 50-100 at a time
Result: Go to "Data Management" → "Import List" to check processing results.
Scenario 4: Seasonal Limited Edition Launch
Situation: Each season we launch themed gift boxes, this season it's "Summer Fruit Gift Box".
How to do it:
- First make sure all fruit products for the gift box are created
- Fill in gift box names and contents in Excel
- Import all new bundles at once
Result: Quick launch of seasonal limited products, no need to create them one by one.
2. Feature Guide
The import bundles feature allows you to create or update multiple bundles at once using Excel, saving you the hassle of entering them one by one. Ideal for batch creating gift box bundles, updating bundle contents, or migrating bundle data from other systems.
Quick Jump: Import Dialog | Field Descriptions | Steps
2.1 Import Dialog
After clicking "Import" you'll see a popup:
| Button / Option | Function |
|---|---|
| Download Template | Download Excel template to fill in bundle data |
| Select Merchant | Choose which merchant to import to |
| Select File | Click to select Excel file, or drag and drop |
| Override existing data | If checked, existing SKUs will be overwritten with Excel data |
| Upload | After confirming file and settings, execute import |
"Override Existing Data" Option
| Setting | When SKU exists | When to use |
|---|---|---|
| Unchecked (default) | Error, this row won't import | Creating bundles |
| Checked | Excel data overwrites system data | Updating bundles |
2.2 Field Descriptions
Fields marked with * are required
Bundle Data
| Field | How to Fill | Notes |
|---|---|---|
| *Bundle Name | e.g., "Holiday Gift Box A", "Mother's Day Bundle" | Required for first row of each bundle |
| *SKU | e.g., "GIFT-001", "BOX-MOM-2024" | Required for first row, cannot duplicate within same merchant |
| Barcode | e.g., "4710001234567" | Fill when bundle has its own barcode |
| Activated | Enter "Yes" or "No" | Defaults to "Yes" if empty |
Component Product Data
| Field | How to Fill | Notes |
|---|---|---|
| *Product SKU | Copy from product list, e.g., "MOON-01" | Required for every row, product must exist |
| *Inventory Type | e.g., "GOOD", "DAMAGED" | Required for every row, code must exist in system |
| *Quantity | e.g., "2", "5"; amount deducted when shipping | Required for every row, must be greater than 0 |
File Format Example
One bundle with 3 products takes 3 rows:
| Bundle Name | SKU | Barcode | Active | Product SKU | Inventory Type | Quantity |
|---|---|---|---|---|---|---|
| Holiday Gift A | GIFT-001 | 4710001 | Yes | MOON-01 | GOOD | 4 |
| TEA-01 | GOOD | 2 | ||||
| BOX-01 | GOOD | 1 | ||||
| Holiday Gift B | GIFT-002 | 4710002 | Yes | MOON-02 | GOOD | 6 |
2.3 Steps
▸ Step 1: Download Template
- Click "Import" button
- Click "Download Template"
- Open downloaded file in Excel
▸ Step 2: Fill in Data
- First row is column headers, don't modify
- Start filling data from second row
- "Bundle Name" and "SKU" are required
- One bundle with multiple products takes multiple rows (from second row, name and SKU can be blank)
- Save file (keep .xlsx format)
▸ Step 3: Upload and Import
- Return to import popup
- Select merchant
- Click "Select File" or drag file in
- Decide whether to check "Override existing data"
- Click "Upload"
▸ Step 4: Verify Results
- Go to "Data Management" → "Import List"
- Find your import record
- Check "Inserted" and "Updated" counts
- If there are failures, click to see error messages
3. FAQ
3.1 FAQ
▪ What if I get "Product not found"?
The product SKU in Excel doesn't exist in the system.
How to fix:
- Go to "Product List" to check if SKU exists
- If it doesn't exist, create the product first then import bundle
- Check for typos (case sensitive)
▪ What if I get "SKU is duplicate"?
Two bundles in Excel have same SKU, or system already has this SKU.
| Situation | Solution |
|---|---|
| Duplicate in Excel | Find duplicate rows, change to different SKU |
| Already in system | If updating, check "Override existing data" and import again |
▪ What if I get "Inventory type not found"?
Inventory type code in Excel isn't set up in system. Common inventory types: GOOD, DAMAGED.
▪ What if I get "Quantity must be greater than 0"?
"Quantity" field has 0 or negative number. Each product quantity must be at least 1.
▪ Where to download template?
"Products" → "Bundles" → "Import" → "Download Template"
▪ How many bundles can I import at once?
| Quantity | Recommendation |
|---|---|
| 1-100 | Import at once |
| 100-500 | Can import at once, may take a few minutes for large data |
| 500+ | Import in batches, 100 at a time |
▪ How many products can one bundle have?
No limit, but recommend no more than 20 for easier management.
▪ Can I import bundles for different merchants at once?
No, each import only selects one merchant. To import for multiple merchants, do separate imports.
▪ What if I find data errors after import?
Only a few errors: Edit directly on bundle detail page.
Many errors:
- Export existing data
- Fix in Excel
- Check "Override existing data" and re-import
▪ When updating bundles, can I just add products without removing?
No. Override is complete replacement, Excel contents become the bundle's new contents. If you originally had products A, B, C and want to add D, Excel must contain A, B, C, D.
3.2 Notes
⚠️ Important Reminders
- Override is complete replacement; bundle products will all be replaced; recommend exporting backup before updating
- "Bundle Name" and "SKU" are required; SKU cannot duplicate within same merchant
- Component products must exist before import; "Activated" can only be "Yes" or "No"
- Large data may take a few minutes; results will appear in "Import List"
4. Related Features
| Feature | Description | Link |
|---|---|---|
| Bundle List | View, search, edit bundles | Go |
| Create Bundle | Manually create single bundle | Go |
| Product List | Create component products | Go |
| Import History | View import success or failure records | Go |