Connect your pricing and inventory files using the Custom Data Source
QuoteCQ allows you to add your own data source, whether that is ERP information or blanket pricing from a supplier.
Follow the below steps:
- Navigate to Configuration and choose Supplier.
- In the Supplier view, choose Data Source.
- Here you will be able to add all your sources of data outside of those already configured.
- Click + to the right of Data Source. (If you need to add a schedule for your file, click here to learn more).
-
Add the name for the data source and select the companies for which you want to configure your data source. This is the name that will appear when running Update Pricing.
- Click the upload icon to begin the process.
- Ensure your file meets all the requirements in the checklist. Check each as you review your file.
Along with the requirements listed here, your file must also have:
-
Supplier Name
-
Manufacturer Name
-
Manufacturer Part Number
-
Unit Price
-
Qty Break
The other options (not required):
-
Currency
-
Minimum Buy
-
Multiplier
-
Lead Time
-
Current Stock Quantity
-
Authorized Reseller
-
Time Stamp
-
SKU
-
Packaging
-
Reeling
-
Product URL
-
DataSheet URL
-
RoHS
-
NCNR
-
Description
-
-
Drag/Drop or upload your CSV file.
- Map the columns from your file to the columns in CalcuQuote.
- Click Next and your file will submit. After it is uploaded, you will have a time stamp to identify when the file was last edited/imported.
- Now, you can run Update Pricing and your new Data Source will be available. The information will appear in line with the other API results, bid sheets and manual pricing.