Skip to main content

How to Bulk Import Products into Stack

Managing a large inventory can be quite the task, but Stack simplifies the process by allowing you to import multiple products at once using a CSV file. Whether you're transferring products from another platform like Shopify or adding new items, this guide will help you bulk import products into Stack effortlessly.

Table of Contents​

Prerequisites for Bulk Importing Products​

Before you start, ensure you have:

  • Access to the Payments > Products page in Stack.
  • A CSV file formatted correctly with your product details.
  • A sample CSV file from Stack for reference.

Steps to Bulk Import Products​

Step 1: Access the Products Page​

  1. Log in to your Stack account.
  2. Navigate to Payments > Products from the main dashboard.

Step 2: Download the Sample CSV​

  1. On the Products page, click Import as CSV.
  2. A pop-up will appear. At the bottom, you'll find an option to download a sample CSV file.
  3. Download this file to understand the required format and fields.

Step 3: Prepare Your CSV File​

  1. Open the sample CSV file using Excel, Google Sheets, or any preferred spreadsheet tool.
  2. Fill out the necessary fields for each product. Required fields may include:
    • Product Name
    • Price
    • SKU
    • Description
    • Category
  3. Ensure each field matches the format in the sample file to avoid errors during import.
  4. Save your completed file as a .csv.

Quick Tip: Double-check your data for duplicate SKUs or special characters that could cause issues.

Step 4: Upload the CSV File​

  1. Return to the Payments > Products page.
  2. Click on the Import as CSV button.
  3. Select your prepared CSV file from your device.
  4. A preview of your file's content will be displayed.

Step 5: Preview & Confirm​

  1. Review the preview to ensure all product details are accurate.
  2. If there are any issues, correct them directly in your CSV file and re-upload.
  3. Confirm everything looks good.

Step 6: Import Products​

  1. Click Import Products to complete the process.
  2. Once the import is successful, your products will be available in Stack, ready for use.

Important Notes & Tips​

  • Errors: If there are issues in your CSV file, an error message will display with details on what needs to be fixed. Correct the errors in your file and re-upload it.
  • Updating Existing Products: Use the same process to update product details. Ensure the SKUs match for seamless updates.
  • Limitations: Stack may have a maximum file size for CSV uploads. Check your file size before uploading.

Troubleshooting Common Issues​

Here are some common problems you might encounter during bulk import:

  • File Format Errors: Ensure the file is saved as .csv and that each field matches the sample format.
  • Missing Required Fields: Double-check that all mandatory fields (e.g., Product Name, SKU, Price) are completed.
  • Special Characters: Remove any special characters that might cause issues during import.

Remember: If you experience issues that you cannot solve, reach out to the Stack support team for further assistance!

Frequently Asked Questions​

Can I update existing products using a CSV import?

No, CSV import cannot update existing products.

What happens if there are errors in my CSV file during the import process?

Error messages will be displayed on the screen. These need to be resolved, and the file must be uploaded again.

Is there a limit to how many products I can import in a single CSV file?

Yes, the maximum file size is 10MB.

Can I use a CSV file from another platform, like Shopify, without any changes?

The format of the CSV should match the sample format, but the file can originate from any platform.

Will importing a CSV file overwrite my existing product data in Stack?

No, products cannot be updated using this functionality, so overwriting is not possible.