Merge product data

Our AI can not only read PDFs – it can also semantically link structured data from Excel, CSV or your PIM system to your documents. This means that you can search and evaluate free texts (e.g. B. PDF product catalogs) and structured data (such as technical properties or contact persons from tables) together.

💡 What does that do for you?

✅ Smarter responses: Combination of marketing copy and technical data

✅ Better filterability and semantic matching

✅ Concrete, data-driven answers to technical and contextual questions

✅ Manage large product portfolios at scale

🔗 PDF + Excel + PIM for better AI results

Here's an example of what your merged product data will look like in the end.

▶️ Merged Data - How it works

There are 2 methods: Simple Matching & Advanced Matching

Simple Matching - Make sure that the product name in your spreadsheet (Excel, CSV, PIM, or similar) is exactly the same as the text documents (PDF)

✅If your product is described in Excel as a gaming laptop. Your document must also be called Gaming Laptop.pdf

❌ As soon as your document or the entry in your spreadsheet differs, e.g. "Gaming_Laptop" and "Gaming Laptop.pdf", then Simple Matching will not work.

Advanced Matching - Often, the product names are always found in the same place in your text documents. For example, the product name is always in the header or footer. Alternatively, the product name can always be found in the headline or always in the exact first sentence of the first paragraph.

• Make sure that your documents have a uniform structure.

• Now you can tell the FoxBase Workbench that the product name is always in the footer.

• The system now applies AI to add your documents to your row in the spreadsheet based on the product name that's in the footer.

✅ If the product name in the table is Gaming Laptop and in the footer is Gaming Laptop, then you will succeed

❌ If the product name is Gaming_Laptop in the table and Gaming Laptop in the footer, then the Advanced Matching will fail to correct incorrect answers → source

Send us your spreadsheet and documents!

Prepare the spreadsheet and documents so that either Simple or Advanced Matching can work. Once you're done, get in touch with support@foxbase.de

⚙️ Requirements & Tips:

• Make sure your Excel columns are clearly named (e.g., "RAM," "Processor," "Display Size").

• Product names or IDs must match exactly for the link to work.

• The better the structure of your data, the smarter the search works.

🔍 Related Articles

Prompting, in order to show complete Data

• Your data fits and is extensive, but your AI answer does not show all the data you have in mind? Check out the prompting to learn how to control the AI.

Enrich product data (coming soon)

• You have structured your table well, but know that the content such as e.g. Contact persons always appear in the documents. Then take a look at the article Enrich product data. You don't need to fill in the column for your variety of products yourself. Let our AI do the work.

Relationship between documents and product data (coming soon)

• Whether a product belongs to one document – or many products are spread over many documents: Our AI supports all variants such as 1 to 1, 1 to many, many to 1 and many to many.