In this article, we will cover:
- How to add a CSV Product Feed
- How to prepare your CSV file for upload
- How to view your products
- How to use the filter
- How to archived/unarchive products
- How to Sync your feed to update your Product Feed
- How to delete a Product Feed
- How to export a CSV file
How to add a CSV Product Feed
- Go to top right hand corner and click on your name
- Click on Team Settings
- Click on Product Feeds
- Click on +Add
- This will open a new pop up on the right hand side
- Click on CSV
- Click Next
- Click Upload and pick your CSV file
- Click Add
- Now your CSV file will appear in the list
How to prepare your CSV file for upload
Your Product CSV file can include the following:
- sku: the product code. Each sku must be unique in file for each individual item/product.
- brand: the name of the brand
- name: the name of the product
- description: the description of the product
- image_url: the url of the product image
- currency: which currency the product is being sold in. For example, GBP, USD, EUR...
- categories: what category this product fits in. If it's multiple categories, you must put a comma between categories.
- url: the url of the product
-
availability: what the availability of the product is. Choose from the following options:
- in_stock - default if not provided
- out_of_stock
- preorder
- available_for_order
- discontinued
- pending
-
status: what you want the status to be in TINT
- active - default if not provided
- archived
-
price: what the price of the product is. Prices should not contain symbols other than
.
to separate the decimals (e.g.9.99
for 9.99) -
sale_price: the sale price if you have one. Prices should not contain symbols other than
.
to separate the decimals (e.g.9.99
for 9.99) -
sale_price_starts_at: when the sale on this product starts. Dates must be in ISO8601 format (e.g.
2022-03-01T19:48:41+00:00
) -
sale_price_ends_at: when the sale on this product ends. Dates must be in ISO8601 format (e.g.
2022-03-01T19:48:41+00:00
)
The following needs to be included for the CSV file to upload correctly:
name
sku
description
- the description can be blank but the column needs to be in the CSV file
You need to make sure that the file has no duplicate SKUs and that there are no line breaks in the fields.
You can also download a sample CSV to see how the file is constructed. You can either find this when you click on Product Feed > +Add > CSV > next and click on View Sample CSV or
click here to download it now.
How to view your products
- In Product Feeds, click on ... next to the CSV file that you would like to see the products list for
- Click on View Products
- This will load the list
- Now you will be able to look through your product list
You can also view the detail of every single product if you hover over the line item you want to look at and click the following button: and it gives you an overall view in a popup the right hand side.
How to use the filter
Inside the view products, you have the filter so when you have a lot of products you can search for them easily.
The options:
Search - This option is for searching what comes under Product which comes from the name in the CSV file
Brand - This option is for filtering by brand which is picked up from your CSV file
Category - This option(s) is picked up from your CSV file
Availability - This option(s) is picked up from your CSV file
Active/Archived - with this option, you can see active products or archived. Active is the default if not filled in on the CSV file
The options that come up in the filter are based on your CSV file and what it contains so the more information that's in the CSV file, the more options you will see. This is what my sample CSV file contains:
How to archived/unarchive products
You can archive or unarchive products inside the View Products without having to upload your CSV file again.
- Click on ... next to the item that you want to archive or unarchive
- This should move the item to the Active side of the filter or the Archived side of the filter.
How to Sync your feed to update your Product Feed
When you need to update the CSV file uploaded in TINT, do the following:
- In Product Feeds, click on ... next to the CSV file you would like to update
- Click on Sync Feed
- This will open a new pop-up on the right-hand side
- Click Next
- Click Upload and pick your CSV file
- Click Add
- Now your CSV file will be updated and replace the old one. This will also update any of your previously tagged content. For example, if you have deleted a product line in the CSV file, this will also remove itself from the content that was tagged with that product.
How to delete a Product Feed
To delete a Product Feed:
- In Product Feeds, click on ... next to the Product Feed you would like to delete
- Click on Delete
- A popup will appear in the middle of the screen saying: This action will permanently delete your product feed application. Are you sure you still want to continue?
- Click on Okay to continue with deleting the Product feed
- The Product Feed will disappear from the list
How to export a CSV file
- In Product Feeds, click on ... next to the Product Feed you would like to delete
- Click on ...
- Click on Export to CSV in the dropdown
- The file will automatically download
If you run into any issues with your CSV Product Feed, please don't hesitate to contact Support at support@tintup.com.
Comments
Please sign in to leave a comment.