Jump to content

Search the Community

Showing results for tags 'csv'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Forum
    • Welcome to the Forum
    • Customize with code
    • Commerce
    • Feedback on Your Site
    • Images & Videos
    • Pages & Content
    • SEO
    • Products
    • Resources
  • Colorado Designers's Topics
  • Squarespace Forum Club Guidelines's Topics
  • Austin, TX Designers's Club Discussion
  • New York City Designers's Club Discussion
  • Berlin Designers's Club Discussion
  • SEO Experts's Club Discussion
  • Photographers's Club Discussion
  • Graphic Designers's Topics
  • London Designers's Topics
  • Podcasters's Club Discussion
  • Custom Coding Help's Club Discussion
  • Atlanta, GA Designers's Topics
  • Seattle, WA Designers's Topics
  • San Diego, CA Designers's Topics
  • Dallas, TX Designers's Topics
  • Australia Designers's Club Discussion
  • Minnesota Designers's Topics
  • Minnesota Designers's Topics
  • Copywriters's Topics
  • France Designers 🇫🇷's Topics
  • France Designers 🇫🇷's Topics
  • Portland, OR Designers's Topics
  • Canadian Website Designers's Club Discussion
  • Los Angeles Designers & Devs's Club Discussion
  • South African Designers's Club Discussion
  • Brazil Designers's Club Discussion
  • Developers's Club Discussion
  • German Circle Members's Topics

Find results in...

Find results that contain...

Date Created

  • Start


Last Updated

  • Start


Filter by number of...


  • Start



About Me




Expert ID

  1. Hi there, I have a list of names I need to display on a Squarespace site like a team page. Ideally it would be formatted like a blog or a content section so I can update the names or add a link/image in the future. Currently in a csv but could be reformatted. So far everything seems to require manual input. Any ideas? Is there a way to structure my file so that Squarespace will import it through the Wordpress import function? Or should I use a custom code block to create a table of sorts? Really hoping to avoid manually entering all 140 names. Thanks!
  2. Hello, I am in the process of migrating my dad's web store from Magento to SquareSpace. I am trying to see if I can bulk-import his catalog with the images included. I created this test csv file, and it almost works besides the Hosted image section. Product Id,Variant Id,Product Type,Product Page,Product Url,Title,Description,SKU,Price,Sale Price,On Sale,Stock,Categories,Tags,Weight,Length,Width,Height,Visible,Hosted Image URLs ,,Physical,shop,star-wars-solo-hobby-box-24-packs,Star Wars Solo Hobby box 24 packs,"Topps Star Wars Solo: a star wars story 24 pack hobby box, with 2 hits including 1 auto or sketch card guaranteed.",887521069972,79,,No,1,Non-Sports/Star Wars,,,,,,Yes,https://www.oldtimehobbies.net/pub/media/catalog/product/2/0/20200124_133103_2_.jpg This is the link to the image: https://www.oldtimehobbies.net/pub/media/catalog/product/2/0/20200124_133103_2_.jpg The only error I get is: Row Error 2 Categories not assigned Try assigning these categories manually The image does work if I upload it to imgur. I get the same error as above. This is the link to it: https://i.imgur.com/3MesYWu.jpeg Now I don't want to upload 988 images to imgur individually. Is there anything I can do to fix this?
  3. I am in the process of importing my products using the upload template CSV. Many of my products have multiple variants. According the the documentation, "you only need to enter the Products Page URL for the first variant." When I leave the "Product Page" column empty for variants, however, I receive an error for each after import reading: Product page not found Make sure the URL corresponds to an existing product page When I try filling in the "Product Page" column for each of the variants (I am using "shop"), the system interprets each row as its own unique product, and I have a bunch of unnamed products rather than variants. As far as I can tell after many reviews, there are no other errors within my CSV.
  4. To others in my same boat...I thought a quick explanation would be helpful. I was trying to create a pinterest catalog for my shop and couldn't quite figure it all out, and there is little to no information out there on how to really do it. I only have a handful of physical products, and well over 100 digital files in my shop. So, the provided CSV file that you can find in the "inventory" section of your shop wouldn't work for me. Those of you with just physical products can have a file created for you by clicking on the "export all" button on the top right of your Inventory screen of your shop. You can actually select specific items to export by clicking on the empty circle to the left of each item in your inventory, then pushing the export button on the top right. It may automatically download a CSV file to your computer, or you can click on the file that pops up on the dropdown menu. You're going to get more info than you made need in the CSV file, so you may need to edit it. That's up to you. Back to creating your own CSV file...I clicked on their example of a CSV file to know what I needed to add to a CSV file of my own. Sidenote, they actually require less now, than what their example says. There are actual requirements listed on this Pinterest page, which are the following: Required fields: id (You can decide what the id is) title (The title you have it listed as in your shop) description (something that describes your item...physical, digital, and so on) link (a direct link to the item in your shop) image_link (right click on your image, and select "copy image link" to find your image link) price (the non-sale price that you have it listed) availability (type "in stock" if it's available) condition (although this isn't required, it helps with setting up the catalog...ex. new, used, refurbished.) You may be aware of those requirements, for those who don't hopefully that is helpful. To I don't have excel, because I use google sheets. To start I filled out the top of the table with all the different requirements...as listed above...id, title, description, link, image link, price, and availability. Then I started filling in the requirements for each item. Yes, in order to get a CSV file with all my digital items, I created it my own. Finding out what the image link was, was silly to figure out...because of how easy it is. It took me longer to figure out than it should have, and I didn't find any info out there about it. When you are on the item's page right click on the image, and then select "copy image link" to get the link for you add to the table. After I added all the info for 140 items from my shop to google sheets, I needed to create a CSV file link. I tried saving it to google drive, and they won't accept that link. So after searching once again, I finally found some random video on youtube, that showed how to "publish to web". The video was old, and of course google sheets has been updated. So... Click on File, Share, Publish to Web. The popup has options. I made sure the "entire document" was selected, as well as "Comma-seperated values (.csv)", then I clicked publish. It will ask you if you want it published. Click yes. Then use the link provided, as your CSV link to paste into the required section in the pinterest catalog. Then click submit and cross your fingers that it works...haha! To be honest after trying over and over again...I was shocked it actually worked!! I know these steps are basic, and for some they may know exactly what to do. For the rest of us, I wish I had someone to show me what to do. It would have saved me to much time and frustration. Sidenote, my digital items loaded fine. My physical items listed with "only 1 in stock" got denied. Which I can understand. When it sells it would require that item to be removed from the catalog, and I'm not sure how easy that is to manage. I've never used this newer catalog option. As far as listing things on sale...under the price section on the CSV file, unless you permanently have them listed on sale, its best to do the regular price. I've even learned when linking blog posts about sales, they become irrelevant when the sale is over. These are the tips that have worked for me. I hope they work for you too, however things change often enough so this info may need to be updated. We can also hope that Pinterest and Squarespace have an easier way to integrate in the future.
  5. Hi, Has anyone experienced data missing when downloading the csv file for a range of orders? Any suggestions where to look for the missing form fields? Thanks, Greg
  6. Hi There I can not import a csv file of email addresses – always get the same error message: "The first column of your CSV must contain at least one email address." Of course first column contains nothing but an email address. Also the doc has exactly three columns as requested. Nothing works. Even if I download a list that has been created within squarespace, open, export from numbers as csv and import it again – I get the same message. Also tried to export on an pc and exel > same result. I'm desperate. Has anyone experienced issues like these and has an idea how to solve?
  7. This information used to be present in spreadsheets exported from the Orders listing in commerce. Now it isnt. This makes it incredibly difficult to process shipping rates. Was this done intentionally to discourage users from handling their own shipping?
  8. Site URL: https://www.magnusoncustomstamps.com/shop/lovingletter When I make my product, the customer types what they want their product to say. I want to take that information and save it as a csv file. That way I can import it into illustrator and have it type all the orders for me. It isn't an option when I click download csv from the orders page. And the only other way I found is also attached here. But you would have to do each product individually. So that wouldn't work. My goal would be to take the orders each day, save it as a cvs file, input it all into illustrator and have it all typed up. All the finetuning such as alignment and size I would do manually.
  9. Site URL: https://www.transformational-empowerment.com Hi all, I am quite new to Square space and trying to import subscribers to my mailing list via a cdv file. This file looks correctly set up to me, first column email addresses, then first name, last name. But an error message appears, telling me the first column needs to contain at least one valid email address. Working on MacOS 10.15.7 MacBook Air. Happens in Safari, Chrome and Opera bowser. Anybody how could give me a hit or help? Best, Christian
  10. I have designed my site and now ready to import product inventory. Is there a way to import "additional info" or does it have to be added to each product individually. I am asking because there is not a column for it on the "csv" template.
  11. I have a custom form a customer needs to fill out during checkout. How can I add these custom fields to the CSV download?
  12. I am in the process of importing my products with the upload template CSV. I have all of my images hosted within our company Google drive, and have added the public share links to my CSV under "Hosted Image URLs." After importing, though, only a blank square with a grey diagonal slash is visible where an imported photo should be. My guess is this is because my URLs don't end in .jpeg, .png, etc. Is there a way to get a link to my images hosted in Drive so that I won't encounter this problem? Is there a different hosting service I should be using that will automatically generate a link with an image extension?
  13. Hi, when exporting the orders information as a csv in Squarespace > Commerce> Orders, there is no option to include or exclude certain product information in the csv, such as weight. Can we customise the exported data that is included in the csv? We need to be able to modify the csv for our logistics partner. Thanks for your help.
  14. Does anyone know of a programmatic way to remove entries from the "Files" list in the Link Editor? (7.0/Montauk) Sure, you can manually select "Delete" on each file, but that is so clumsy when you have a lot of junk files. And why would you have a lot of junk files? Because every time you import a product .csv file, apparently that filename gets added to the list of files in the Link Editor. Then if you later try to use the Link Editor to link to a static file you actually care about, you have to scroll thru all the .csv files you have ever imported. So, before I get started on setting up our new store (with products whose prices will be updated daily via .csv imports) I am wondering if there is a way to deal with Link Editor file clutter. Anyone have any suggestions? (Am I the only one who's ever had this problem? I am mystified as to why the product import .csv clutter up the list. You can't reuse them, you can't download them, and you can't tell how big they are or when they were uploaded. In fact, even failed import attempts add filenames to the Link Editor list. I contacted Customer Care about this a year ago and they said they'd look into it, but I just did a little test and found that the problem still persists.)
  15. Is it possible to use the SFTP, to upload a CSV file, then have a custom page that would display the CSV data in a Table?? I'd prefer, if I could add custom code to a Squarespace page, that would read the CSV file. We would like to have the CSV file uploaded nightly and require a SFTP location to upload the file to. I created a folder called Inventory, with a test.html file, but I am not sure how to view it. I was going to have the Test.html file read the CSV file and display the information. I assumed, I would be able to go to https://www.strongbridge.us/Inventory/test.html
  16. Site URL: https://www.phelpsrefinishing.com/ Last December I tested the whole bulk editing process on a copy of my client's site, so I could be sure the same procedures would work on January 1 when every price had to be updated. Now I'm in the same process for an August 1 update, and have not succeeded yet in making any test imports work. Of course the test site uses different SKU numbers, so I export the test site inventory, make a test change, and import it back to the site. The import result is just duplicate products with completely new SKU numbers -- no change to the products displayed on the test site. It worked so well last December that I didn't make many notes on how I did the bulk editing...except for notes on how to get the variants updated. Tech support hasn't solved this with me yet. Anyone else have ideas on what I'm doing wrong? Meanwhile, I'll keep trying different things and if I find a solution, will post it here.
  17. Site URL: https://www.olobobtop.com/shop Hi, I have a small shop and would like to sync the products to Facebook/Instagram. I don't have a SS Commerce Plan, just a Business Plan. I export my products csv and upload to FB, but many of columns don't match and it's impossible to work out how to change them. I don't understand why SS would kick out a csv that doesn't match other site's import rules. Is there an easy workaround anyone has found, that doesn't require a fee like SquareFeed, or signing up to a SS Commerce Plan? I only need to do it once and have very few products. Thanks!
  18. Guest

    CSV variants

    Hi all, I have over 1000 products that I have managed to import, however, I am struggling with the product variants. When I upload, the variants seem to import into the product but it doesn't create individual entries, I can do this manually on separate line entries but this would take me forever and I need to import my live file every day. Any ideas on how I fix this, please?
  19. Site URL: https://www.alfonso.com.au Hi Guys! Trying to upload a csv file of products to add to my online shop but keep getting an error on the csv. "Some rows couldn't be fully imported. Fix those rows to import them again" View Error: "Missing Column, add product ID Column. Can't see any errors in the csv and wondered why?
  20. Not being able to download the Additional Information fields in the csv download makes a lot of extra work on the accounting side!!! Please Squarespace-- you collect this info, please make the change & allow us to access it in the csv download!!!
  21. Help! I just spent a good chunk of time updating all of my prices in Numbers on my Mac, saved the .csv file, and it updated a few quantity changes I had made, but absolutely none of the price changes. Help! I REALLY don't want to spend even more time doing it item by item from the site itself. I'm moderately tech savvy, and nothing promising came up when I tried to google this issue. TIA! Dani
  22. Hey all! I am curious about you guys having problems importing products by csv, when you have a huge amount of items (maybe greater 100 or even more?). I had to set up a store only for 40 items but he fact, that you can only assign an "image url" to the item, problems formatting the csv file correctly and so on took me a lot of time until I just decided to do it manually. Can anyone share his/her experience here? I just saw, a lot of forum posts regarding the csv problem.
  23. Site URL: http://www.shapelyevents.com/shop Hello, please help! again. I am to switch my site from squarespace 7.0 to 7.1. In that I realize that I have to start from scratch. I'm starting with my store and i'm trying to get my inventory from one site to another using the csv sheet as recommended. I exported it from my current live squarespace store. I HAVE NOT EDITED IT. LEFT IT AS IS! When i try to import it on the new platform, 7.1, i'm getting an error message and nothing is changing. I would hat to have to manually add all these items. I dont understand why there's an error if I havent changed anything. Things to note: - I am still in my trial period. I haven't made the site live as yet being that I wanted to build it then launch it when I can swap it out with the current one. Is this a factor? because I'm also getting a pop up telling me that certain features are only available in a commerce plan but I would think I could be able to build out my store using the imported csv before I launch it. I've attached photos of my process and what I'm getting. Someone...anyone...please help.
  24. Site URL: https://www.colonia-jewellery.com/ My problem is getting 200+ images to load into my site using the download csv file. I have tried a site called postimages, where I uploaded the images and got the direct link url to appear. I copied this into the hosted url column. As a trial I uploaded just one product. The image didn't appear. Does anyone have any ideas how to fix this issue , please?
  25. Site URL: https://www.spacegallery.co.uk/prints/test I am trying to import <br> into description field - it shows when i inspect the page - but does not render - I know that Saurespace stopped supporting <br> how do I get around this - I need to import 100's of descriptions with line breaks in
  • Create New...

Squarespace Webinars

Free online sessions where you’ll learn the basics and refine your Squarespace skills.

Hire a Designer

Stand out online with the help of an experienced designer or developer.