THEVAN3D

Hello, 

I need to find a way to create a section/field on a page for my customers to check serial numbers of the items. 

Basically user should be able to input a serial number in the text field and click "Check" button. Then site should check whether or not whatever user wrote is in my database and therefore give the user either green tick or a red X, or something like that as a confirmation. 

And I have that serial numbers database in Excel sheet. 

What do I do? How do I make this work? Is there some kind of addon for that? 

On 3/29/2023 at 8:25 AM, Ai-KonicGraphics said:

For those who are still having the issue of “add PRODUCT ID column, here’s how I fixed it. 

I’m switching my art shop from 7.1 to the fluid engine. 

1. export the file from squarespace "inventory" (the original site)

2. "import" the file into Excel.

3. make all changes without removing anything except all the listing under PRODUCT ID & VARIANT ID - make sure everything under those 2 column are blank.

4. Save as (comma separated values) .csv not the .CSV UTF-8 (comma delimited) because it won’t work. 


5. Before you import the file to the site, add a listing (this something you’ll delete later) - make a fake listing with the basic information.

6. Then "import" the file to the squarespace inventory. 

PS: I did not change the name of the file saved.

Hope this helps others.

This does work, but I'm in a situation where I ABSOLUTELY HAVE TO use the UTF8, because the descriptions that I put in the file are in a language that requires UTF8 and I am absolutely sure this used to work just fine, because I have a ton of products imported like that. 

So technically, this is a new issue right now, May 2023 and your solution (though it works) is not an actual solution, but rather a workaround of sorts. Hope someone fixes it soon.