How to Map Product Import Columns with AI in StoreRobo

The StoreRobo Import Export App for Shopify can map the columns in your product import file to the matching Shopify product fields using AI. Instead of mapping each column manually, you can generate the mappings with a single click, review the suggestions, correct them where needed, and then run the import.

AI-assisted mapping works with all supported import sources — Local, URL, FTP/SFTP server, and WooCommerce API.

In this guide, you’ll learn how to:

• Upload a product import file and open the custom mapping screen.
• Map the product columns automatically using AI.
• Review confidence levels and correct the suggested mappings.
• Re-run or reset the mappings before importing.

1. From your Shopify admin dashboard, go to Apps > StoreRobo > Home.
2. Navigate to the Import section.
3. Under Import file from, choose the required import source:
   • Local
   • URL
   • FTP/SFTP server
   • WooCommerce API
4. Upload or select the product import file.
5. Under Choose Separator, select the separator used in your file. The default is Comma. To check the file contents before importing, select Show preview of the file.
6. Under Select data type, select Products.
7. Click Upload.

Under Import template, select the template as Custom.

A mapping screen will appear as shown. Here, you can map the columns based on:

• General
• Image
• Variant
• Inventory

For successful import, ensure the Title field is mapped.

To map the fields automatically, click Auto-map columns.

StoreRobo analyzes the columns in your file and suggests the corresponding Shopify product fields, along with a confidence score for each suggestion.

Confidence score	Result
80 and above	Mapped automatically and marked High confidence
60–79	Mapped automatically and marked Low confidence
Below 60	Left unmapped for manual review

The summary at the top of the mapping screen shows the total number of columns mapped by AI, along with the number of High confidence and Low confidence mappings.

AI-generated mappings are suggestions. Review them before running the import.

To change a mapping:

1. Locate the required Shopify product field.
2. Open the corresponding File columns dropdown.
3. Select the correct column from the import file.

When you manually change an AI-generated mapping, StoreRobo treats the updated selection as a manual mapping and removes its confidence label.

To generate the mappings again, click Retry auto-mapping.

If you have already edited some mappings manually, the Re-run AI mapping window appears with two options:

• Re-map all columns — AI replaces all current mappings, including your manual edits.
• Map only unmapped columns — your manual edits are preserved, and AI fills only the columns without a selection.

Select the required option and click Map columns. To close the window without re-running, click Cancel.

To discard the current mappings and start again, click Reset. This clears both AI-generated and manually edited mappings and restores the mapping screen to its default unmapped state.

Once you have reviewed and finalized the column mappings:

1. Configure the required product import Options.
2. Click Import to import the products. Alternatively, to schedule the import, click Schedule.

StoreRobo uses the finalized mappings shown on the screen when processing the import. The AI only assists with mapping the fields; it does not start or complete an import on its own.

You can also save the finalized mapping as a preset and reuse it for future imports from the same source. For more details, refer to Simplify Data Management with Shopify Import/Export Presets.

• Non-English column headers: StoreRobo uses translation-based and semantic matching to identify the corresponding Shopify field.
• Columns with a header but empty sample values: AI suggests a mapping based on the column header.
• Empty column headers: Columns without a header are excluded from mapping.
• Duplicate column headers: Duplicate columns are not mapped automatically and must be reviewed and mapped manually.
• AI mapping unavailable: If automatic mapping cannot be completed, you can continue using the regular manual column mapping process.