CIMPRESS - ProductData
Product Data 1.0
S.O.P.
Version 1
9/28/2023
OBJECTIVE
Cimpress has specific requirements for data exports of both Vantage Products and SanMar products.
At any time, Cimpress may request full data exports of Vantage Products or SanMar products.
At any time, Cimpress may also send a partially filled out spreadsheet with a subset of products for us to provide data for.
Both any Spreadsheet sent, and the exported Spreadsheet contain Data Columns that have been specified by Cimpress and are necessary for the input of Data into their system. DO NOT remove any columns or edit the column headings in the file.
If the exported Spreadsheet is missing any data that they are requiring, STOP, do not send the file and reach out to Frank Amendola for guidance before continuing.
The following pages show how Product Data Exports are handled by the Cimpress Account CSR.
ALL VANTAGE GOODS
VAT – CUST SVC – INTEGRATIONS – CUSTOM – CIMPRESS
1. Click the Cimpress Product Data tab.
2. Select “All Vantage Goods” from the list.
3. Click the “Run Report” Button.
4. The report will generate in the background and will download in the browser download folder when complete.
5. Move the file to your desktop.
6. Open the file with Excel.
7. If Excel prompts you to fix errors, click OK.
8. Save the file.
9. Review the file to check for any issues.
10. Send the file.
ALL SANMAR GOODS
VAT – CUST SVC – INTEGRATIONS – CUSTOM – CIMPRESS
1. Click the Cimpress Product Data tab.
2. Select “All SanMar Goods” from the list.
3. Click the “Run Report” Button.
4. The report will generate in the background and will download in the browser download folder when complete.
5. Move the file to your desktop.
6. Open the file with Excel.
7. If Excel prompts you to fix errors, click OK.
8. Save the file.
9. Review the file to check for any issues.
10. Send the file.
VANTAGE FROM FILE
VAT – CUST SVC – INTEGRATIONS – CUSTOM – CIMPRESS
1. Click the Cimpress Product Data tab.
2. Select “Vantage From File” from the list.
3. Click the “Choose File” button.
4. Find and select the file that Cimpress sent from your computer and click OK.
5. Click the “Run Report” Button.
6. The report will generate in the background and will download in the browser download folder when complete.
7. Move the file to your desktop.
8. Open the file with Excel.
9. If Excel prompts you to fix errors, click OK.
10. Save the file.
11. Review the file to check for any issues.
12. Send the file.
SANMAR FROM FILE
VAT – CUST SVC – INTEGRATIONS – CUSTOM – CIMPRESS
1. Click the Cimpress Product Data tab.
2. Select “SanMar From File” from the list.
3. Click the “Choose File” button.
4. Find and select the file that Cimpress sent from your computer and click OK.
5. Click the “Run Report” Button.
6. The report will generate in the background and will download in the browser download folder when complete.
7. Move the file to your desktop.
8. Open the file with Excel.
9. If Excel prompts you to fix errors, click OK.
10. Save the file.
11. Review the file to check for any issues.
12. Send the file.
SANMAR FROM ID
VAT – CUST SVC – INTEGRATIONS – CUSTOM – CIMPRESS
1. Click the Cimpress Product Data tab.
2. Select “SanMar From ID” from the list.
3. Enter the Field Number that contains the product ID from the spreadsheet (for Column A you would enter 1)
5. Click the “Run Report” Button.
6. The report will generate in the background and will download in the browser download folder when complete.
7. Move the file to your desktop.
8. Open the file with Excel.
9. If Excel prompts you to fix errors, click OK.
10. Save the file.
11. Review the file to check for any issues.
12. Send the file.