When to Use a Custom Product Attributes Import
Conjura Retail Analytics automatically retrieves product data from your integrated eCommerce platforms like Shopify and BigCommerce. This data includes essential attributes like product category, brand, and SKU, which are vital for in-depth analysis and reporting.
If your product attributes, such as categories or sizes, aren't fully captured in your eCommerce platform, you can use the Custom Product Attributes Import to ensure your data in Retail Analytics is complete and accurate.
Why Import Product Attributes?
Accurate product attribute data is essential for meaningful product analysis. Whether you're analyzing product performance by category, size, or color, having detailed and correct product attributes ensures your insights are reliable, leading to better business decisions.
How to Use a Custom Product Attributes Import
You can manually add product attributes in two ways: via CSV upload or by direct entry into the app.
Important: Assigning Product Category 1 manually in the Product Table will overwrite the category normally pulled from your eCommerce platform or OMS.
CSV Upload Method
For large-scale updates, the CSV method is recommended. Here’s how:
Navigate to the Custom Data Import tab under ‘Connectors’ on the left-hand side navigation bar.
Select ‘Product Attributes’.
Download the CSV Template File.
Fill out the spreadsheet offline with the desired fields:
Product Key (pre-populated)
Product SKU (pre-populated)
Product Name (pre-populated)
Product Brand (pre-populated, defaults to 'Unknown' if not available in Shopify/BigCommerce)
Product Category 1 (Category normally pulled from Shopify/BigCommerce)
Product Category 2
Product Category 3
Product Colour
Product Size
Save the completed file.
Navigate back to the product costs import in Retail Analytics.
Before uploading your file, delete all rows in the table. You can see an example by hovering over "How to do it."
Either drag and drop your file or click 'Upload File'
Click 'Continue' to ensure all columns are correctly mapped.
Select ‘Submit Data’.
Your data will sync overnight and appear in your report.
Direct Entry Method
For smaller updates or single entries, you can manually input data directly into the app:
Navigate to the Custom Data Import tab under ‘Connectors’.
Select ‘Product Attributes’.
Enter the required data directly in the interface.
Submit the data.
Your updates will sync overnight and reflect in your reports the next day.