The required information in a ProductDB database
The main component of a ProductDB setup is a database saved as a CSV file. You will upload the file and use that to create a product catalog in AdButler. You can then search that catalog to create ad items for each item that you want to serve as an ad.
There is no limit to the number of products or columns that can be in the file. However, a database must contain the following information:
- Identifier - Unique identifier for the product.
- Title - Name of the product.
- Description - Description about the product.
- Brand - Product brand.
- Seller ID - Unique identifier for the seller.
- GTIN - UPC or EAN of the product.
You do not need to use these exact terms as the column names. Here's a sample database:
| BRAND | DESCRIPTION | PRICE | UPC | VENDOR ID | RATING | ||
|---|---|---|---|---|---|---|---|
| 10000 | Blue T-shirt | Adidas | Comfortable cotton t-shirt | 21.99 | 12121 | 12345 | 4.5 |
| 10001 | Black Running Shoes | Nike | Lightweight men's running shoes | 89.99 | 21212 | 23456 | 4 |
| 10002 | Red Baseball Cap | Adidas | Snapback cap with logo | 18.99 | 90909 | 12345 | 3.5 |
You will search for products in your catalog when creating ad items. While you will most likely use one of the required information as search parameters, you will be able to search for any text that's in the catalog. You can make the most out of your catalog by adding information that will make it easier to filter or search through your products. For example, a clothing store can have a column in their database that indicates a product's category (e.g. headwear, jackets, underwear).
