Skip to main content

Documentation Index

Fetch the complete documentation index at: https://help.sendocki.io/llms.txt

Use this file to discover all available pages before exploring further.

Arriving at Sendocki with a catalog of tens, hundreds, even thousands of products? No need to re-enter everything. Bulk import lets you push your entire catalog (with variants, photos, prices, costs) in a few minutes — with ready-to-use template and preview before validation.
The import is designed to be risk-free: Sendocki displays every product that will be created or modified before validating. You decide line by line whether a duplicate should be updated or ignored.

When to use bulk import?

Migration from another tool

Coming from another dashboard, a homemade Excel, an ERP. Export from the old one, import to Sendocki.

Bulk update

Seasonal price change, supplier cost adjustment, variant additions — modify your Excel and re-import.

Launching a new range

Twenty new products to add at once — much faster than manual creation.

Supplier synchronization

Your supplier sends you an Excel file with the new products and stocks. You import it as is each week.

Step 1 — Download the template

Before importing, download the official Sendocki template: a CSV/Excel file with the right columns, the right order, and filling examples.
1

Open the import dialog

Products → Catalog → ‘Import’ button at the top right
Download the import template
2

Click 'Download template'

Dedicated button — an Excel file saves to your computer
3

Open the template in Excel or Google Sheets

You see the expected columns + a few example lines to delete before import
Why use the template: it avoids errors of badly named headers, missing columns, or bad format. Imports fail 80% of the time due to format issues avoidable with the template.

Expected columns in your file

For a simple product (no variants)

ColumnRequiredExampleNotes
sku_productTSHIRT-BLACK-MUnique product identifier
product_nameSport T-shirt Black Size MName displayed to customer
typesimpleFor a product without variants
price149.00Sale price in MAD
costRecommended65.00Purchase cost (for margin calc)
imagesOptionalhttps://...,https://...URLs separated by commas
tagsOptionalsport,summerTags separated by commas

For a variable product (with variants)

The parent product is on a line with type=variable, then each variant on its own line with the variant columns filled:
ColumnRequiredExampleNotes
sku_productTSHIRT-SPORTParent identifier (repeated on each variant line)
product_nameSport T-shirtParent name
typevariableIndicates to the system there are variants
sku_variant✅ (for variants)TSHIRT-SPORT-BLACK-MUnique identifier of the variant
variant_name✅ (for variants)Black / Size MShort variant name
variant_priceOptional149.00Specific price (if different from parent)
variant_costOptional65.00Specific cost
For a variable product with 20 variants (5 colors × 4 sizes), you will have 20 lines in your file — one per variant, all sharing the same parent sku_product.

Step 2 — Upload and preview

1

Drag and drop your file (or click to browse)

Accepted formats: CSV (.csv), Excel (.xlsx, .xls)
File upload zone
2

Sendocki analyzes your file

Automatic detection of columns, simple vs variable products, existing duplicates
3

Detailed preview

For each product, you see:
  • Proposed action: 🆕 Create / 🔄 Update / ⏭️ Ignore
  • Type: simple or variable
  • Detected variants (if applicable)
  • Conflicts: if the SKU already exists with different info (e.g. different price)
Detailed import preview
4

Statistics at the top of the list

  • Total file lines
  • Unique products (vs variant lines)
  • Total variants
  • Simple / variable products
  • New to create
  • Proposed updates
  • Conflicts to arbitrate

Step 3 — Arbitrate conflicts (if necessary)

For each product whose SKU already exists in your Sendocki catalog with different data, you see the conflict detail:
Conflict arbitration per product
For each product in conflict, you decide individually:

🔄 Update

The new info from the file replaces the old info in Sendocki. Useful if your source file is more recent.

⏭️ Ignore

The product stays with its current info in Sendocki. Useful if you don’t want to overwrite modifications made in the meantime.
If all conflicts are to be handled the same way, use the global button “Update all” or “Ignore all” at the top of the list — faster than line by line.

Step 4 — Launch the import

1

Click 'Import'

Button at the bottom of the dialog, after arbitrating conflicts
2

Progress bar

For large imports, Sendocki shows you the progress in real time
3

Final confirmation

You see the exact result:
  • ✅ X products created
  • 🔄 Y products updated
  • ⏭️ Z products ignored
  • ❌ W products in error (with detailed list)
Successful import confirmation
4

Automatic return to catalog

Your new products are visible immediately in the list

Handle import errors

If certain lines fail, Sendocki lists them precisely with the reason:
Error typeProbable causeHow to correct
Missing SKUsku_product cell emptyEnter a unique SKU
Invalid priceText instead of number, comma instead of dotFormat 149.00 (decimal point)
Duplicate SKU in fileSame SKU on 2 lines (simple product)Keep one line per product SKU
Inconsistent typesimple with variant columns filled (or reverse)Choose consistent: simple OR variable
Invalid column formatColumn badly named, missingStart from template
3 options depending on volume:
Error volumeRecommendation
< 10 linesCorrect directly in file, re-import
10-100 linesDownload error report (CSV), correct in bulk, re-import
> 100 linesGeneral format issue — check columns or contact support

Best practices before a big import

  • Delete empty lines
  • Standardize SKUs (no spaces, no special characters)
  • Consistent numeric formats (decimal point, no currency symbol in cell)
  • Valid image URLs accessible publicly
Before importing 5000 products at once, export a sub-file of 5 representative lines (a simple + a variable + one with conflict). Do a test import to validate the format.
Export your current Sendocki catalog before a big bulk import. In case of error, you have a recovery point to reimport.
For very large catalogs, do several imports of 2000-3000 products rather than a single one. Faster, easier to diagnose in case of error, less risk of timeout.
Your Sendocki SKUs must match those of your Shopify/YouCan store for future orders to link automatically to the right products. Verify before importing.

Typical use cases

  1. Export your catalog from the old tool in CSV
  2. Open in Excel, compare columns with Sendocki template
  3. Rename columns to match template (product_namenom_produit, etc.)
  4. Do a test import on 5 lines
  5. Import the complete catalog
  6. Verify in the Sendocki catalog that everything is correct
  1. Export your current Sendocki catalog (Export button in Catalog)
  2. Modify the price column (and cost if applicable) in Excel
  3. Re-import the modified file
  4. In the preview, all your products will appear as “Update”
  5. Click “Update all”
  6. Your new prices are applied to future orders
  1. List the new products in the template (just the new ones, not the entire catalog)
  2. Import — all will appear as “To create”
  3. No conflicts (since SKUs are new)
  4. Validate the import — the new range is online
Your supplier sends you every Monday an Excel with their current products + stocks + prices.Routine:
  1. Receive the supplier file
  2. Adapt if necessary (columns / format)
  3. Import into Sendocki
  4. Validate conflicts: usually “Update all” (the supplier has the right up-to-date info)
If you change your SKU system (e.g. TSH-B-M becomes TSHIRT-BLACK-M):
  1. ⚠️ Warning: changing a SKU = new product for Sendocki, not an update. Your old products will remain, and new ones will be created.
  2. Better: do an export, create a “new_sku” column in Excel, and contact support for assistance — it’s a special case requiring a rename rather than a classic import.

Frequently asked questions

No strict limit. We recommend batches of 2000-3000 products to stay smooth. Beyond that, contact support for an assisted import.
Only if you fill the images column with new URLs. If the column is empty for an existing product, its current photos are preserved.
No — the product template manages the catalog (product info). Stock is managed separately from the Inventory page, with its own potential import.
No automatic cancellation. You must:
  • For newly created products: go to the catalog, filter by add date = today, delete in bulk
  • For erroneous updates: re-import the previous file (before modifications) with “Update all”
  • Complex cases: contact support
Yes — image URLs must point to publicly accessible files (your CDN, your e-commerce store, a shared public Google Drive folder, etc.). Sendocki downloads the image from the URL at the moment of import.
UTF-8 encoding required for CSV. With Excel: “Save as → CSV UTF-8”. With Google Sheets: CSV export is UTF-8 by default. If characters badly displayed after import, re-export your source file in UTF-8.

What’s next?

Product catalog

See and manage your imported products

Inventory

Assign stock to your products in your warehouses

Warehouses

Configure your storage locations