Setting up a new Product Catalog

[pat_kelly]

Hello community! I may be in over my head but so far I love the way Airtable organizes things but can’t get it to work for me yet. I am a producer and have an ecommerce website and sell about a dozen items online using Webflow. I am trying to set up a base to help me track my sales and inventory and because some of my products come in different sizes and colors and I am having a real hard time extracting the pertinent information from my imported orders CSV file and organizing it so that I can use it. Here is a screenshot of my imported table, maybe I just need the right formula? Thanks in advance.

[M_k]

Hi @pat_kelly

At first glance, I would use multi select field for your option field, that is if the options will be the same, but different selection for each customer. You might also want to remove the quotation marks from each of the options, since it might interfere with other field options i.e. Formulas. Also, would you be able to just use 200ml, without the word “size”? It can make the data cleaner. Just thought I would ask.

Hope these suggestions will help, as you begin your journey into Airtable.

Mary Kay

[pat_kelly]

Thanks Mary,

You are right, the quotation marks do interfere with the formulas that I have been trying to write, I just don’t know how to remove them, and they are imported along with everything else. I am beginning to feel like I might need some one on one help to get this done.

[M_k]

Hi @pat_kelly

Where is your data being imported from? Is it a spreadsheet? Maybe you can clean the data at the source?

Mary

[pat_kelly]

Thanks Mary,

The data is a downloaded file from my Webflow ecommerce site, I am unable to clean up the data myself and I am unsure how it is formatted in the back end of my site. I was hoping to come up with a formula that would clean up the options column of my table.

Pat

[M_k]

Hi @pat_kelly

I managed to find a post that might help your use case, regarding the double quotes.

Take a look and see what you think.

Unwanted quotation marks in pulled through by formula Ask the community

I think this post has the solution I need. But, I can’t figure out how to apply it to my existing formula. I have a 4-part title (4 fields concatenated into 1 to make up a title). Not all 4 parts are used in every record, so I wanted my formula to remove added punctuation or spaces in case of a blank field in the concatenated string. I can’t figure out how to keep that aspect of my formula and add the aspect in this forum that gets rid of the unwanted quotation marks when part of the title ha…

[ScottWorld]

pat_kelly:

I am beginning to feel like I might need some one on one help to get this done.

Hi Pat,

If you have a budget for your project and you’d like to hire an expert Airtable developer to help you with this, please feel free to contact me through my website at ScottWorld.com.

Best,
Scott

[pat_kelly]

This looks great! I will give it a try later today.

[Angel_Baena]

You don’t say how you import the data but my suggestion would be to use an intermediate app like Integromat or Zapier, so you can treat the data and make it automatic.

Angel

[pat_kelly]

Thank you Angel. That is exactly what I ended up doing.