Bulk upload CSV File

Could someone please explain to me how I can bulk upload a CSV file of over 9000 products to my store? 

 

Many Thanks 

3,111 Views
Message 1 of 4
Report
1 Solution
Alumni

Solution

Hi @Zaqi, I can see that this is your first post. Welcome to the Community!

 

To bulk import your items into your Square Dashboard, please follow these steps: 

 

  1. Visit Items in your online Square Dashboard.
  2. Click ActionsImport Library.
  3. Select Modify Item Library to add new items and update existing items, or Replace Item Library to delete all existing items and replace them with your uploaded items.
  4. Click Next > Click Download your item library to download your current inventory Excel (.xlsx) or .CSV report. Click Export. Select between Excel or CSV.
  5. Open the file saved to your computer in a spreadsheet program.
  6. Fill in the template columns with your item information. When editing the template, keep the following tips in mind:
    • Don’t change any of the information in the Item ID column or delete empty columns.
    • Leaving the category field blank will leave the item as Uncategorised.
    • New categories will be created for any new values identified in the Category column.
    • Leaving the price field blank will create a variable-priced item.
    • Leaving the modifier field blank will default the modifier to off. Place a “Y” in the appropriate Modifier Set column if you’d like a specific modifier applied to an item.
  7. Save the edited file to your computer.
  8. Drag and drop the file into the upload area or click select it from your computerUpload.
  9. Review your changes and click Confirm to upload your new item library.

If you need to revert to a recent version of your Item Library, you can undo an item import from the Items page of your online Square Dashboard > Actions > Undo Catalogue.

 

Check out this article on our Support Centre about importing items into your Square Dashboard.

 

I hope this information is helpful, please let me know if you have any more questions, I’d be happy to help! 


 

View Solution >

3,107 Views
Message 2 of 4
Report
3 REPLIES 3
Alumni

Solution

Hi @Zaqi, I can see that this is your first post. Welcome to the Community!

 

To bulk import your items into your Square Dashboard, please follow these steps: 

 

  1. Visit Items in your online Square Dashboard.
  2. Click ActionsImport Library.
  3. Select Modify Item Library to add new items and update existing items, or Replace Item Library to delete all existing items and replace them with your uploaded items.
  4. Click Next > Click Download your item library to download your current inventory Excel (.xlsx) or .CSV report. Click Export. Select between Excel or CSV.
  5. Open the file saved to your computer in a spreadsheet program.
  6. Fill in the template columns with your item information. When editing the template, keep the following tips in mind:
    • Don’t change any of the information in the Item ID column or delete empty columns.
    • Leaving the category field blank will leave the item as Uncategorised.
    • New categories will be created for any new values identified in the Category column.
    • Leaving the price field blank will create a variable-priced item.
    • Leaving the modifier field blank will default the modifier to off. Place a “Y” in the appropriate Modifier Set column if you’d like a specific modifier applied to an item.
  7. Save the edited file to your computer.
  8. Drag and drop the file into the upload area or click select it from your computerUpload.
  9. Review your changes and click Confirm to upload your new item library.

If you need to revert to a recent version of your Item Library, you can undo an item import from the Items page of your online Square Dashboard > Actions > Undo Catalogue.

 

Check out this article on our Support Centre about importing items into your Square Dashboard.

 

I hope this information is helpful, please let me know if you have any more questions, I’d be happy to help! 


 

3,108 Views
Message 2 of 4
Report

Hi, I started building my website this afternoon and so far so good, until I wanted download ready to upload as this question asks. I have used other sites so put a generalised subcat item in for downloading, so I can learn format and fields.  However I cannot find the 'Actions' you mention.  I have read the article but it basically says what you do above. Help would be appreciated.

2,829 Views
Message 3 of 4
Report
Square

Hi @LadyTJ welcome to the Seller Community 👋 

 

Apologies for the delayed response! 

 

You can find this action in your Square Dashboard > Items > Actions 

 

 

Screenshot 2023-02-14 at 09.05.51.png

 

Let me know if you have any questions! 

Breffni
Community Moderator, Ireland, Square
Sign in and click Mark as Best Answer if my reply answers your question

After a wonderful three years supporting the Seller Community, I've moved teams!
Check out article "A Contact Guide to the Seller Community" to reach out to current Seller Community Moderators.
Thank you for all the memories and connections—here’s to new adventures! 
2,817 Views
Message 4 of 4
Report