What can we help with?

Add, view, and edit the Vendors you order products from in the eTailPet system in the Product Vendors area. You can import and export spreadsheets containing Vendor details, add new Vendors, search for existing Vendors, and more. Keep reading to find out how you can use this area so you can stay on top of your store's operations!

To access the Product Vendors area, go to Manage Catalog > Product Vendors in the main menu.

How to Use the Product Vendors Area

Here is everything you can use in the Product Vendors area to add new Vendors, search for existing Vendors, and import or export files containing Vendor details:

1. Export — Click on the Export button in the upper left to export an Excel spreadsheet listing out all of your Vendors.
2. Import / Update Vendors — You can add or update Vendor records by importing a spreadsheet. Click on Import / Update Vendors to either Export a Sample File or Upload an Excel File. Learn more in the Import / Update Vendors section below.
3. Search — You can enter a Vendor ID or Name in the Search bar and press Enter on your keyboard to find a Vendor.
4. Import / Update Product-Vendors — You can use the Import / Update Product-Vendors button if you want to import a file that has your store's Product records and their respective Vendors, along with a full list of your Vendors. Click on this to either Export a Sample File (which will contain all of your store's Vendor records) or Upload an Excel File. Learn more in the Import / Update Product-Vendors section below.
5. Export Product-Vendor Sample — The Export Product-Vendor Sample button acts as a shortcut for you to export a spreadsheet template that also has all of your Vendor records. Use this sample file to record your store's Product-Vendor relationships and complete Vendor details.
6. Add New — Click on the Add New button in the upper right to add a new Vendor for your store. You can learn more about the Add New form in the Add New Vendor or Edit Existing Vendor section below.
7. Show Entries Per Page — If your Vendor records span multiple pages, you can select the number of entries that will display per page from this drop-list. Your options are 10, 25, 50, and 100.
8. Data Table — The data table shows complete details for all of your store's Vendors. Here is each column you can view:
   • ID — This column shows the Vendor ID numbers used internally by the system.
   • Name — This column shows the Vendor names.
   • Shipping Fee — This column shows the shipping fee you pay for a Vendor to ship products to your store.
   • Minimum Order Amount — This column shows the minimum dollar amount you have to order to get products from a Vendor.
   • Account Number — This column shows the Vendor's Account Number with your store.
   • Sales Representative Name — Larger Vendors may have a representative communicate with your store about orders. This column shows the name of a Vendor's sales representative.
   • Email — This column shows the Vendor's email address for Purchase Orders.
   • Return Email — This column shows the Vendor's email address for credits needed for your store(s).
   • Phone — This column shows the Vendor's phone number.
   • Address — This column shows the Vendor's street address.
   • City (not pictured above) — This column shows the Vendor's city.
   • State (not pictured above) — This column shows the Vendor's state.
   • Zipcode (not pictured above) — This column shows the Vendor's ZIP Code.
   • Return Eligible (not pictured above) — This column shows Yes or No depending on whether or not you can return products to this Vendor.
9. Sort by ID — The data table is sorted by Vendor ID number by default. Click on the Arrow icon to reverse the sort.
10. Vendor ID — You can click on a Vendor ID to delete the Vendor or edit its details.
11. Sort by Column — If you want to sort the data by a column other than by ID, you can click on the Arrow next to the column name. Click once to sort, or click again to reverse the sort.

Add New Vendor or Edit Existing Vendor

• To add a New Vendor, click on Add New in the upper right.

• If you want to edit a Vendor's details, select a Vendor by clicking on its ID in the data table, then click on Edit.

The Vendor Form will open for you. Here is everything in the Vendor Form that you can set up and use:

1. Name* — Enter the name of the Vendor.

2. Attached Universe Vendor (Beta) — This feature was not viable and will be removed in the future.

3. Account Number — Enter the Vendor's Account Number.

4. Address — Enter the Vendor's street address.

5. City — Enter the city in which the Vendor is based.

6. State — Enter the state in which the Vendor is based.

7. ZIP Code — Enter the ZIP Code in which the Vendor is based.

8. Order Email Address — Enter the Vendor's email address that they use to receive orders.

9. Phone — Enter the Vendor's phone number.

10. Sales Rep Name — Enter the name of the sales representative who is your point of contact for the Vendor (not necessarily the actual Sales Rep).
    
    

11. Shipping Fee* — Enter the dollar amount of the shipping fee you pay to get orders from the Vendor.

12. Minimum Order Amount* — Enter the minimum dollar amount your store has to spend to order from the Vendor.

13. Return Eligible — Check the box if items from the Vendor is eligible for returns.

14. Purchase Order / Work Order Return Eligible — Check the box if a Purchase Order or Work Order from the Vendor is eligible for returns.

15. Order In Cases — Check the box if you want to order from the Vendor in units of cases.

16. Store — You can add a local Vendor Account Number in this table for your reference. You can select All stores or a specific store from the drop-list.

17. Account — Enter the local Vendor's Account Number for the selected store.

* Required Field

Import / Update Vendors

To import a file that will add or update Vendor records, click on Import / Update Vendors (this is not the same as Import / Update Product-Vendors, which is about the products Vendors carry).

• You can click on Export Sample File to start with a template.

This is how to fill out each column of the file:

1. ID — Enter the Vendor's internal ID number.

2. Name — Enter the name of the Vendor. This field is required.

3. Shipping Fee — Enter the dollar amount of the shipping fee you pay to get orders from the Vendor. This field is required.

4. Minimum Order Amount — Enter the minimum dollar amount your store has to spend to order from the Vendor. This field is required.

5. Account Number — Enter the Vendor's Account Number with your store.

6. Sales Rep Name — Enter the name of the sales representative who communicates with you on behalf of the Vendor.

7. Email Addresses — Enter the Vendor's email address for purchase orders.

8. Return Email Addresses — Enter the Vendor's email address for requesting Vendor credits.

9. Phone — Enter the Vendor's phone number.

10. Address — Enter the Vendor's street address.

11. City — Enter the city in which the Vendor is based.

12. State — Enter the state in which the Vendor is based.

13. ZIP Code — Enter the ZIP Code in which the Vendor is based.

14. Return Eligible — Enter Yes if items from the Vendor are eligible for returns. If they are not, leave this blank.

15. Case Vendor — Enter Yes if you want to enable this vendor to convert products to cases of the product in your Purchase Orders. Leave blank if you don't have cases set up in your system. 

Import / Update Product-Vendors (Products by Vendor)

Importing Product-Vendors (Products by Vendor) is different from normally importing vendors. With the Product-Vendors file, you will have Vendor records as well as the Product-Vendor relationships (which Vendors you order each product from).

Here is how to import a file of Product-Vendors (Products by Vendor):

Step 1: Export Vendor Template File

In order to import Vendor Costs so you can update them, you first need to download the import template file. Here's where you can download a sample file:

1. Click on Manage Catalog in the eTailPet main menu.
2. Click on Product Vendors.
3. Click on Export Product-Vendor Sample.
4. Save the file to your device.

Step 2: Fill Out the Product Import Template

The Import tab of the spreadsheet contains product data you will be importing to properly associate each item with its Vendor. Open the file so you can edit information. Make sure to save your changes. Here is an example of how the import template's columns look in Microsoft Excel:

1. system_id — You can get the System ID by exporting products from your catalog. However, as long as you have a UPC, you can leave this blank. If you include system_id, be sure to check out the Tips section towards the bottom of this article to make sure they are formatted correctly. Please Note: You must include either system_id OR UPC.
2. upc — If you have the system_id from a product export, you can leave the UPC field blank. If you include UPCs, be sure to check out the Tip sections at the end of this article to make sure they are formatted correctly.
3. vendor_id — There is a tab in your template called Vendors that includes a list of your vendors and their IDs.
4. vendor_sku — This column is for the vendor SKU, which is supplied by the vendor. This could also be the manufacturer product ID.
5. default_cost — This column is for the default cost for a product you purchase from this Vendor without discount.
6. is_default_vendor — Enter Yes if the Vendor is a default vendor for your store. Enter No if not.

Step 3: Fill out Vendor Records

To update Vendor details or fill them out, click on the Vendors tab on the bottom of Microsoft Excel.

This is how to fill out each column of the file:

1. ID — Enter the Vendor's internal ID number.

2. Name — Enter the name of the Vendor. This field is required.

3. Shipping Fee — Enter the dollar amount of the shipping fee you pay to get orders from the Vendor. This field is required.

4. Minimum Order Amount — Enter the minimum dollar amount your store has to spend to order from the Vendor. This field is required.

5. Account Number — Enter the Vendor's Account Number with your store.

6. Sales Rep Name — Enter the name of the sales representative who communicates with you on behalf of the Vendor.

7. Email Addresses — Enter the Vendor's email address that they use to receive orders.

8. Return Email Addresses — Enter the Vendor's email address from which they will receive credits from you.

9. Phone — Enter the Vendor's phone number.

10. Address — Enter the Vendor's street address.

11. City — Enter the city in which the Vendor is based.

12. State — Enter the state in which the Vendor is based.

13. ZIP Code — Enter the ZIP Code in which the Vendor is based.

14. Return Eligible — Enter Yes if items from the Vendor are eligible for returns. If they are not, leave this blank.

15. Case Vendor — Enter Yes if you want to enable this vendor to convert products to cases of the product in your Purchase Orders. Leave blank if you don't have cases set up in your system. 

Step 4: Import the Product-Vendors (Products by Vendor) Template

After you've finished filling out the Import template, you can upload it into the eTailPet system. Here's how:

1. Click on Manage Catalog in the eTailPet main menu.
2. Click on Product Vendors.
3. Click on the Import / Update Product-Vendors in the upper right. This will open two options.
4. Click on Upload Excel File.
5. Upload the file from your device.

Related Topics

Adding and Importing Products

Change or Remove Products

Batch Cost and Price Updates

Vendor Credits

Purchase Orders

Inventory Counting

Frequently Asked Questions

Q: What's the difference between Import/Update Vendors and Import/Update Product-Vendors?

A: Import/Update Vendors only updates vendor contact and account details. Import/Update Product-Vendors does that too, plus which products you buy from each vendor and their costs.

Q: What does the Case Vendor field do?

A: Enter Yes to let that vendor convert products into cases on your Purchase Orders. Leave it blank if you don't use cases with that vendor.

Q: How do I delete a Vendor?

A: Click on the Vendor's ID in the data table. That takes you to a page where you can delete it or edit its details.

Q: Do I need to fill in both system_id and UPC when importing Product-Vendors?

A: No, just one. Leave the other blank, and make sure whichever one you use is formatted correctly to avoid import errors.

Q: Should I fill out the Attached Universe Vendor field?

A: No, this feature isn't functional and will be removed in a future update. Skip it when filling out the Vendor Form.

Q: I have a question, but I can't find my answer here. How do I get more assistance?

A: You can ask any question at the number listed here. Contact our support team at (323) 370-0738 for the U.S. and (888) 370-2363 for Canada.