Creating Products with a Spreadsheet

Ablestar Bulk Product Editor allows you to create new products using spreadsheets.

Format Spreadsheet

Once your spreadsheet is formatted with product-level identifiers and variants, you are ready to upload.

In our example above, there are three products, and the first product (example-t-shirt) has two variants. All variants of the same product share the same 'Handle'. This is the field that groups them in one product. The option labels are stored in the 'Option Name' fields (like 'Size' or 'Color), and the data for those options are stored in the 'Option Value' fields (like 'Small', or 'Red').

Upload Spreadsheet

From the Ablestar Bulk Editor dashboard, click 'Spreadsheet Edits' from the menu:

  1. Click Drag and Drop Spreadsheet button to start upload

Preview Upload

You will see a Column mapping preview of your data:

  • Map columns: If your column names do not match existing data in your store, you will click to manually map each column by clicking the Select field button at the top of each column to specify. The system will remember your naming conventions in future imports:

  • Remove columns: (x) out of any columns you need to remove
  • Note Red Indicators: if you are importing brand new products to your database, the red 'This row doesn't match any products' indicator is expected

When you are ready, click the Run edits button to start processing the import.

Import History

At any time, you can access your product history from the Ablestar Bulk Editor menu by clicking 'History' > Imports tab:

Click any row to see the full detail of the import and from the detail view you have several options:

  • Download error log: see a full list of any error notifications
  • Edit Products: return back to your original product filter for further edits
  • More Actions → Rename: give your import a unique name that you can find more easily
  • More Actions → View configuration: see the upload configuration of your columns and fields

✅ Tips and Troubleshooting

(05.82)

Did this answer your question? Thanks for the feedback There was a problem submitting your feedback. Please try again later.

Still need help? Contact Us Contact Us