The majority of store owners construct their directories in Excel. Costs, SKUs, stock matters, and provider information all live in one workbook that gets sorted, upgraded, and versioned over months of sourcing. The problem begins when it’s time to relocate that workbook right into WooCommerce.
WooCommerce’s native importer just checks out CSV files, and transforming an Excel workbook to CSV damages more information than it protects.
In this short article, we’ll reveal you how to import WooCommerce items from Excel without transforming anything, and how to maintain your directory updated from the same workbook in time.
Why the Default WooCommerce Importer Denies Excel Files
WooCommerce consists of a totally free importer under Products ‘All Products ‘Import , but it approves only two documents kinds: CSV and ordinary TXT. It can not open.xlsx or.xls data at all. The majority of overviews recommend a basic repair: open the Excel documents, save it as CSV, and import the transformed data.
That conversion action is where Excel item information obtains harmed:
- SKU corruption: Excel strips leading absolutely nos from text stored as numbers. A SKU like
004512comes to be4512the minute the documents is saved as CSV, and every product referencing that SKU breaks. - Encoding damages: Typical CSV exports utilize Windows- 1252 inscribing by default. Accented personalities, currency icons like EUR and ₤, and clever quotes show up in WooCommerce as garbled message unless the export is by hand readied to UTF- 8
- Date and number reformatting: Excel transforms days to locale-specific layouts (03/ 15/ 26 vs. 15/ 03/ 26 and reformats costs based upon local settings. Price organizing days and numerical areas rarely survive the conversion undamaged.
- Multi-sheet loss: A workbook with vendor listings on multiple tabs exports only the active sheet. Anything on the various other tabs vanishes from the CSV without alerting.
- Formula artifacts: Columns improved solutions export their calculated worths, yet comma-containing outcomes (like full summaries) can damage CSV column parsing when pricing estimate policies are not managed appropriately.
WP All Import gets rid of the Excel to CSV conversion action totally. It parses.xlsx and.xls workbooks natively, checks out the information exactly as Excel shops it, and maps inbound columns to WooCommerce areas without requiring any kind of fixed column names.
Mapping Excel Columns to WooCommerce Item Area
WP All Import does not need your Excel file to comply with any type of column calling convention. Headers like Item Call, Thing Title, and even personalized distributor classifies all work, because Automatic Configuration reads the real data in each column and pairs it with the proper WooCommerce area. You don’t need to download a theme or comply with a schema.
The table below is a referral, not a requirement. It shows where WooCommerce shops each kind of product information once it has actually been imported, which works to understand if you ever before intend to inspect what the plugin did with a certain column:
| Excel Column | WooCommerce Item Field |
|---|---|
| SKU | _ sku |
| Item Call | post_title |
| Description | post_content |
| Brief Summary | post_excerpt |
| Normal Rate | _ regular_price |
| Sale Price | _ sale_price |
| Stock Quantity | _ stock / Manage Stock |
| Category | product_cat |
| Picture link | _ thumbnail_id and _ product_image_gallery |
| Size, Color | _ product_attributes or pa _ * |
| Parent SKU | post_parent |
2 columns are worthy of additional attention for variable items. The characteristic columns (such as Size and Shade) must have the Made use of for variants establishing allowed during import, and every variant row requires a Parent SKU worth matching its moms and dad product’s SKU. Automatic Arrangement spots and sets up both instantly when those columns exist, whatever you called them in your workbook.
How to Import WooCommerce Products From Excel
With the workbook ready, the import itself takes a couple of mins with Automatic Arrangement.
Step 1: Upload Your WooCommerce Products Excel Data
Browse to All Import ‘New Import in your WordPress control panel and click the Establish automatically banner on top of the screen.
Pick your file resource:
- Submit a data: Select the.xlsx or.xls workbook straight from your computer.
- Download and install from URL: Get in a link to an Excel documents held on a vendor server or shared drive.
- Existing documents: Reuse a workbook already published to
/ wp-content/uploads/wpallimport/ files/ - FTP/SFTP: Pull the Excel file directly from a remote supplier storage server.
Under Select What to Import , select WooCommerce , then Products (Simple, Variable, Grouped)
If your workbook has anything unusual, increase Add Configuration Recommendations and explain it in plain English, such as “Column F consists of numerous photo Links separated by commas” or “Utilize the ListPrice column for routine rate.” Then click Start Automatic Configuration The plugin analyzes the workbook, reads each sheet’s columns, and builds the field mappings instantly.
Step 2: Examine the Automapped Product Fields from Excel
When the analysis completes, the Your Import Is Ready card shows how several item documents were found and the number of fields were mapped from your Excel file.
Click Area Mappings to broaden the checklist. Validate that titles, SKUs, Regular Cost, Sale Price, and photo columns were combined correctly. For variable products, inspect that feature names appear alongside their value columns which the Parent SKU column was identified for linking.
If every little thing matches your catalog framework, click Run Import If a column was misinterpreted or you intend to readjust feature settings, click Manual Configuration to open up the pre-filled design template editor.
Action 3: Preview the WooCommerce Products Live
On the exact same web page, you can likewise click the Preview switch to open a panel close to your area mappings:
- Frontend Sight provides actual product web pages from your theme, so you can verify titles, rates, and image galleries display the way shoppers will certainly see them.
- WP Admin Sight reveals the WooCommerce backend edit screen, verifying the Excel data landed in the appropriate Item Information fields, including the General, Inventory, and Connects tabs.
Browse with several documents utilizing the arrows, including at least one variable product, prior to dedicating anything to the database.
Step 4: Run the Excel Item Import
Click heaven Run Import button on the recap card. WP All Import misses the intermediate screens, takes you to the verification page, and processes the file in background batches to avoid server timeouts on huge workbooks.
When it completes, open Products ‘All Products and spot-check a few things against the initial spreadsheet.
Maintain Your WooCommerce Catalog Updated From the Same Excel Workbook
The initial import is just half the worth. Due to the fact that the Excel workbook stays the resource of reality for pricing and supply, the same data can rejuvenate the brochure indefinitely.
On the Import Settings screen, click Auto-detect to create an Unique Identifier. WP All Import commonly sets the SKU column with the product title, which enables every future import to match incoming rows against existing products and upgrade them in place as opposed to producing matches.
With matching in place, rerunning the import after modifying prices in Excel updates the magazine in mins. You can narrow each upgrade to specific fields: revitalize Normal Cost, Price, and Stock Quantity while leaving summaries, images, and categories unblemished.
If the workbook lives on a shared drive or supplier server, you can additionally set up Scheduling Choices to import it immediately on a daily or once a week schedule using totally free web server cron or the paid Automatic Organizing solution ($ 19/ month).
What Is the Best Method to Import WooCommerce Products From Excel?
The built-in WooCommerce importer can not open Excel files, and the conventional workaround (saving the workbook as CSV) corrupts SKUs, mangles currency icons, and calmly goes down worksheet tabs. For a single import of a straightforward brochure, the conversion could get through. For an active shop, it creates data issues that take longer to deal with than the import itself.
WP All Import allows you import WooCommerce products from Excel due to the fact that it reads.xlsx and.xls workbooks directly, maps columns to WooCommerce item fields instantly on upload, and sets every import with a Distinct Identifier so the exact same workbook can update the directory repeatedly without duplicates. Establish as soon as, and the spreadsheet that currently runs your sourcing becomes the engine that runs your store.
Often Asked Inquiries – Import WooCommerce Products From Excel
Can WooCommerce import products from Excel directly?
No. The built-in WooCommerce importer just approves CSV and TXT data. To import.xlsx or.xls data without transforming them, utilize a plugin like WP All Import, which parses Excel workbooks natively and maps the columns to WooCommerce item areas immediately.
Do I require to convert Excel to CSV prior to importing items?
No. Converting an Excel workbook to CSV strips leading nos from SKUs, scrambles currency symbols, and drops all worksheet tabs other than the active one. WP All Import reads.xlsx and.xls submits directly, getting rid of the conversion step and the data damages that includes it.
What columns should my Excel file have for importing items?
At minimum, include Product Call, SKU, and Regular Cost columns. Suggested enhancements consist of Description, Brief Summary, Supply Amount, Classification, and Image URL. For variable products, include feature columns like Dimension and Color plus a Parent SKU column linking each variation row to its parent.
Exactly how do I update existing WooCommerce items from Excel without producing matches?
Establish the SKU column as the import’s Unique Identifier using the Auto-detect button. When you rerun the import with an upgraded workbook, WP All Import matches inbound rows to existing products by SKU and updates them in position instead of producing replicate listings.
Can I import variable items with qualities from Excel?
Yes. Consist of one parent row per variable item and one row per variant, with characteristic columns like Size and Color and a Moms and dad SKU column on each variant row. WP All Import web links variations to parents immediately and creates the quality dropdowns on your store.
Related Information
