To create product catalogs for gifting, you must first import the products that creators can choose from. You can use a CSV (comma-separated values) file to import products and their details into your Aspire account.
Note: You can only use one import method. If you import products using a CSV file, the option to import from Shopify will no longer be available (and vice versa).
How to Import Products Using a CSV File
Step 1: Prepare Your CSV File
Before uploading your file, ensure it meets these requirements:
Only CSV files are supported.
File size must be under 10MB.
For CSVs with product variants:
Column | Description |
Product Type* | variant |
SKU* | The Stock Keeping Unit for the Variant (unique per row) |
ParentSKU* | The ID or SKU for the Product in which the variants are grouped |
Product Title* | The name of the Parent Product |
Image URL* | The URL image for the product (must be public) |
Variant Title | The name of the Variants (internal) |
Variant Image URL | The URL image for the variant (must be public) |
Option1 Name | Name of the variant Option 1 (ex. "Size") |
Option1 Value | The unique value for the variant Option 1 (ex. "Small") |
Option2 Name | Name of the variant Option 2 (ex. "Color") |
Option1 Value | The unique value for the variant Option 2 (ex. "White") |
For CSVs with product without variants (simple):
Column | Description |
Product Type* | simple |
SKU* | The Stock Keeping Unit for the Product (unique per row) |
Product Title* | The name of the Product |
Image URL* | The URL image for the product (must be public) |
Learn more about the columns shown in the sample product CSV file.
Learn more about the columns shown in the sample product CSV file.
Column | Description |
Collection ID | The unique identifier for each collection. |
Collection Name | The name of the collection that you want to add the product to. |
Product Handle | The handle is used in the URL of the product page. A valid URL handle can contain letters, dashes, and numbers, but it can't contain any spaces. |
Collection Image | Enter the URL for the collection image. |
Product Description | The description of the product, which provides details about what the product is. |
Product Vendor | The name of the origin or source of the products that you sell. If you make the product yourself, then the value of the vendor column would be your company name. |
Product Category | A label that describes the type of product. |
Product Tags | Add keywords to group and filter products:
|
Product Status | Indicates whether the product is available to your customers. If this column is present, then it needs a value. If the column isn't present, then the product status is automatically uploaded as
Note: All products—regardless of status—will be available for creators to select. |
Product Image Src | Enter the URL for the product image. This column is not specific to variants. Use the variant image column to add variant images. |
Variant Price* | The price of the product or variant. Only include the monetary value without a currency symbol. For example, |
Variant Compare At Price | The original price of the variant if the price has been reduced and you want to display the price comparison. Only include the monetary value without a currency symbol. For example, |
Variant Inventory Quantity | The number of items you have available in stock of the product or variant. The default value is |
Variant Image Src | Enter the URL for the variant images. Ensure added URLs are functioning image URLs. Use the delimiter |
Variant Cost | How much it costs you to make or acquire the product or variant. Only include the monetary value without a currency symbol. For example, |
Option1 Name | Create variants for a product that has more than one option, such as size or color, by entering its name. Each combination of option name values for a product can be a variant of that product, such as A product can have up to 4 options. If a product has only one option, then this value should be |
Option1 Value | If a product has more than one option, such as size or color, then enter its value. For example, a value for a color option could be |
Learn how to prepare your images.
Learn how to prepare your images.
Because CSV files can only contain text, all image references must be publicly accessible URLs. Image URLs must use an https:// protocol and not require login or password access.
Depending on the location of your image file, take one of following actions:
If the files are only on your computer, then you must upload them to an image hosting service, such as GoDaddy, OneDrive, Dropbox, or BucketLynx, and then obtain their URL.
If your products have images on your website, then you can copy the current image URLs and use them in the CSV file.
Step 2: Upload a CSV file.
Go to Settings > Product Fulfillment > Products.
Click Import Products and select Upload CSV.
Drag and drop your CSV file or click Upload file.
Step 3: Review Import
Use the CSV Field Mapping tool to match Aspire's headings to your CSV column headers. Unassigned fields will not be imported.
Click Next when finished.
Step 4: Review & Confirm
Use the Preview screen to verify that your data is correctly mapped. If everything looks correct, click Start Import.
After processing, you’ll see the number of successfully imported records and any invalid records that could not be imported.
Click Close to finish. Your products and collections will now appear in the Products tab.
Frequently Asked Questions
Will inventory be deducted when creators select products?
Will inventory be deducted when creators select products?
No. Inventory tracking is not supported for CSV imports, and Variant Inventory Quantity will not decrease.
Can we update previously imported products?
Can we update previously imported products?
Yes. Re-importing a CSV with updated product data will update existing products.
We use SKU as the unique identifier.
Will importing a file with existing SKUs create duplicates?
Will importing a file with existing SKUs create duplicates?
No. Aspire checks the SKUs to avoid duplicates.
How do we upload Product and Variant images?
How do we upload Product and Variant images?
All images must be added as publicly accessible URLs.
Can we upload multiple images for one product or variant?
Can we upload multiple images for one product or variant?
Yes, use the delimiter | to separate multiple image URLs.
Is there a limit to product options?
Is there a limit to product options?
You may include up to 4 options per product or variant.
Can I delete products that were imported by mistake?
Can I delete products that were imported by mistake?
Yes. Products can be deleted directly from the Products tab. Deleting them does not affect future imports — the same Product ID can be re-imported later if needed.
Is there a maximum limit for tags?
Is there a maximum limit for tags?
No, there is currently no maximum limit for product tags.
If your Product Description, Product Titles, Names, etc., have commas, make sure to use quotation marks
If your Product Description, Product Titles, Names, etc., have commas, make sure to use quotation marks
To avoid issues with your product import, make sure to put Product Description, Product Titles, Names, etc., that have commas inside quotation marks. Example: "Eat, Sleep, Repeat TShirt".