Jump to content
Search In
  • More options...
Find results that contain...
Find results in...
Advanced Search

Search the Community

Showing results for tags 'csv'.

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Forum
    • News and Announcements
    • Getting Started With Squarespace
    • Coding and Customization
    • Commerce
    • Selling & Scheduling Your Services
    • Feedback on Your Site
    • Images and Videos
    • Pages and Content
    • SEO and Marketing
    • Site Design and Styles
  • 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. 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.)
  2. 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
  3. 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.
  4. 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?
  5. 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.
  6. 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!
  7. JoPV

    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?
  8. 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?
  9. 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.
  10. 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!!!
  11. 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?
  12. 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
  13. 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.
  14. 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.
  15. 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?
  16. 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
  17. 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
  18. So I've got a client with a current, working commerce site. I'm re-designing their site with a different template, currently in preview mode. Before hiring me, they set up all their inventory in separate product pages. They have roughly 8 categories, but each of those has between 5 to 9 sub-categories; they created a product page for each sub-category. Naturally, having all their inventory segmented like that makes it hard to use tags to sort and organize their content. I exported their entire inventory, added tags and categories in the appropriate columns, and am trying to re-import. Here's where I'm running into issues. I didn't notice the limitation of 200 products per page on a 7.0 template (the template I'm working in and previewing is 7.0). I read that 7.1 templates allow 10,000 products per page, which is great, but the prospect of choosing a new template and re-doing all the design work I've already done is not appealing. To continue testing the import function, I then pared the spreadsheet down to fewer than 200 products, all in the same category. I created a product page just for that category, added that value into the "Product Page" column. When importing that resulting spreadsheet, nothing is imported, with every item having the error "Make sure the product ID wasn't edited". I don't know what this means. This error is only sometimes reproducable - when I imported the spreadsheet containing the entire inventory, these same items from the smaller spreadsheet imported successfully. In short, I have no idea what to do here. Like I mentioned, I can always choose to preview a 7.1 template and test the complete spreadsheet import. Let's say I do that, but I don't like the template for whatever reason: if I change my mind and go back to the template preview I'm using now, will I need to re-set all the font, color, and layout options? They're looking to re-launch soon, but this is turning out to be more work than I anticipated.
  19. I have information that I want to put in a table. What is the best way to do this?
  20. Site URL: https://dressupandparty.squarespace.com Hi, I'm fairly new here but here goes, hope you can help! I am setting up a store which has approx 3000 products in. I have a large spreadsheet of every single product in, and from the supplier, three image files for each product. I am trying to find a way to bulk upload the images for the products in a far quicker way than copying and pasting 3000 links into the spreadsheet. For example: Image file name is 12345.jpg currently stored locally, but I need to host it to be a link. I need a link that is for example www.website.com/anything/12345.jpg. In my spreadsheet I can format the cell to have "www.website.com/anything/*TEXT*" which means I could process ALL links in the sheet at once, as long as they all follow that formula with the image filename at the very end. Is there an easier way to do this? I have found a website that works in a similar way, but when I tried it it wouldn't work properly. Dropbox for example adds a jumble of characters in the web address so this won't do. I'm really struggling to figure it out! I've tried google drive, dropbox, flickr, even squarespace's own static addresses but these still add a jumble of characters! Please let me know if you can help! Thanks, Brendan
  21. Site URL: http://www.metamodernmusicshop.com Hello, Last night I uploaded 5600 products, 200 at a time, using .csv files, based on the Squarespace template. Got that all working...however, none of the items show up in the store. What's the point of the bulk import if they don't show up. When I go to my Inventory, all 5600 items are there and listed as they should. The live URL is www.metamodernmusicshop.com There is one product showing up, but that is because that was an individual entry added via "Add Product" Can someone please guide me as to why this is happening? The monthly commerce plan is my subscription type. Please tell me that all 5600 products have to be manually uploaded...If so, what is the point of a bulk .csv import? Thank you in advance for your help. Really need to get this store up asap in light of everything happening around us. Thank you
  22. hi there I exported my product as CSV, but notice the hosted image URLs are different than the actual URL CSV URL: https://static1.squarespace.com/static/5985d732c534a5778bda2d3b/5ab556911ae6cf2ed3a2f5e4/5aa076e4e4966b07314d2c66/1596206821222/http_%252F%252Fs3.store.hypebeast.com%252Fmedia%252Fimage%252F2013%252F06%252FSunday_Sunglass_19_2.jpg Actual URL https://images.squarespace-cdn.com/content/5985d732c534a5778bda2d3b/1520465637011-W1M4IZCR3U9AM0A34WJS/http_%252F%252Fs3.store.hypebeast.com%252Fmedia%252Fimage%252F2013%252F06%252FSunday_Sunglass_19_2.jpg is there anyway to export the actual URL instead?
  23. had a CLEAN list of 1400 emails and Squarespace import wouldn't allow it. I split into smaller lists of 333 each and IT WORKED! hope this helps yoU!
  24. I have just realised there is an arbitrary limit of 3 to how many options you can import/export. Of course I have a product with 4. Does this mean that I 1) have to manually add the 32 new products with the very clunky web interface? 2) won't be able to bulk update this product in any useful way? ( If I remove the additional option, I get errors about duplicates) This will pretty much make product management impractical. Does anyone have a useful work around?
  25. Site URL: https://www.txyouth.com/store I'm currently revamping our website, especially the store side of things. I'm wanting to keep track of my inventory through the commerce plan, but I can't figure out a way track cost of production for our in house financial team who asks for regular updates. Can anyone think of a work around that would allow too simultaneously track inventory, sale price, price of production, etc on one file exported regularly from Squarespace? I'd rather not have to keep separate files for store inventory and and the treasurers if it's not necessary.
  • Create New...