How to Import Products to WooCommerce from CSV (with

What the Built-in CSV Importer Handles

How to Import Products to WooCommerce from CSV (with from WebJi®, billed in INR with 18% GST on the invoice. Email support@webji.services is 24/7 in Hindi and English (average first reply under 60 minutes). Phone +91 141 4941811 is business hours only. The company has been in this business since 2005.

Step 1: Download and Fill the Sample CSV Template

The fastest correct start is the official sample file:

1. Products → All Products → Import.
2. Click 'Download example CSV' — it contains every recognised column: ID, Type, SKU, Name, Published, regular_price, sale_price, Categories, Images, Attributes, Stock and more.
3. Fill your product data into the columns, one row per product.
4. Keep SKUs unique — they are the update key for re-imports.

Two rules prevent most failed imports: prices as plain numbers (499, not ₹499), and image URLs as full https:// links to accessible files. The mapping step explains how your headers connect to WooCommerce fields; the native importer covers the whole product schema including variables.

Step 2: Column Mapping Explained (SKU, Price, Images)

Column Mapping Explained (SKU, Price, Images). Do this on one site or a staging copy first, then check the public URL in a private window so cache does not hide the result. Stop if the page errors, and email support@webji.services with the step name and the exact error before you repeat it on every account. WebJi® support mail is staffed 24/7 in Hindi and English; the phone line +91 141 4941811 is business hours only.

Step 3: Run the Import and Handle Errors

On SKU, the honest summary is that defaults matter more than brand names — a well-set budget plan outranks a mis-tuned premium one. WebJi® documents its defaults openly and adjusts them per ticket when workloads need it.

Importing Variable Products and Categories

Variable products import as a family of rows:

• Parent row — Type: variable, carrying the name, description and categories.

• Variation rows — one per combination (Type: variation), linked through the Parent column holding the parent's SKU, with each variation's own SKU, price, stock and attribute values (Size: M, Color: Blue).

Categories need no pre-creation — the Categories column creates the hierarchy inline, comma-separated for multiples, with 'Parent > Child' syntax for nesting.

Run a three-product test import before the full file: mapping errors surface cheaply on three rows and expensively on three thousand. Post-import, spot-check a variable product's front end — variations dropdown, prices, stock — before announcing the catalogue live.

After the catalogue comes compliance — the GST invoicing guide sets up invoices.

Large Catalogs: WP All Import and Batching

Two practical notes on column mapping: it interacts directly with caching and database response, and misconfiguration is the most common cause of 'hosting is slow' tickets. WebJi® support checks it as part of standard migrations.

Export Products: Backups and Migrations

Allow 80 and 443 to the world, and restrict SSH (22) or RDP (3389) to known IPs. A site that times out after a firewall change is usually a closed web port, not a dead server. If you lock yourself out, use the console in the client area or email support@webji.services before you reboot in a loop.