Imports and Exports Overview

Aug 14, 2026Aug 14, 2026

Bulk imports and exports are the fastest way to get data into or out of the eTailPet system. This article will show you what areas have the tools and templates you need for your importing and exporting. Take a look!

nando - importing and exporting

System Guide on Imports and Exports

Data Type Template Import and Export Knowledge Articles
Imports & Exports General General information and tips on importing data. Importing Products Best Practices and Troubleshooting
Spreadsheet Tips and Tricks
Customers

Image showing the import and export functions of the Customers page of the eTailPet system.

  1. To import a list of Astro Customer IDs, first you'll need to Export the Astro ID template for import: Go to Customers > Import Astro Customer ID > Get Sample Excel.

    Then after you've added your data to the downloaded template, to Import the Astro ID template: Go to Customers > Import Astro Customer ID > Upload Excel File.
    Image showing the Import Astro ID functions on the Customers page of the eTailPet system.
  2. To Import Customers or Update Customers, first you'll need to Export the template for import: Go to Customers > Import Customers > Get Sample Excel.

    Then after you've added your data to the downloaded template, to Import the Customers and Customer Updates template: Go to Customers > Import Customers > Upload Excel File.
    Image showing the Import Customers functions on the Customers page of the eTailPet system.
  3. To Import Pets or Update Pets, first you'll need to Export the template for import: Go to Customers > Import Pets > Get Sample Excel.

    Then after you've added your data to the downloaded template, to Import the Pets and Pet Updates template: Go to Customers > Import Pets > Upload Excel File.
    Image showing the Import Pets functions on the Customers page of the eTailPet system.
  4. To Export Customer Data: Go to Customers > Export, and you can choose to download a CSV or Excel file.
    Image showing the Export Customers functions on the Customers page of the eTailPet system.
Import and Export Customers
Product Universe / Public Products

Image showing the Import/Export Products and Inventory functions on the My Products page of the eTailPet system.

  1. To Import Product Inventory, first Export the template for import: Go to Manage Catalog > My Products > Import Product Inventory > Export Sample File.

    To Import and Update Public Products Inventory: Go to Manage Catalog > My Products > Import Product Inventory > Upload Excel File.
    Image showing the Import Product Inventory functions on the My Products page of the eTailPet system.
  2. To Import Products, first Export the template for import: Go to Manage Catalog > My Products > Import/Update Products > Get Sample Excel.

    To Import and Update Public Products and retail pricing: Go to Manage Catalog > My Products > Import/Update Products > Upload Excel File.
    Image showing the Import Products functions on the My Products page of the eTailPet system.
  3. To Export items from your Public Product Catalog: Go to Manage Catalog > My Products and select the products you want to download. Click Export in the upper left and you can choose to download a CSV or Excel file.
    Image showing the Export Products functions on the My Products page of the eTailPet system.

Importing and Updating Inventory

Adding and Importing Products

Export Products

Private Products

To Import / Update Private Product Inventory, change the Catalog Type as described below and follow the instructions in #1 in the section above.

To Import / Update Private Products, change the Catalog Type as described below and follow the instructions in #2 above.

Image showing the Catalog Type filter on the My Products page of the eTailPet system.

To work with Private Products in bulk, go to Manage Catalog > My Products and on the left, change the Catalog Type to Private.

Private Products

Private Product Setup

Product Vendors

Image showing the Import / Export Vendor functions on the Product Vendors page of the eTailPet system.

💡Please Note: The Vendor Import/Export functions on this page can be confusing to some, so here is some clarification:

  • The functions on the left of the page, Export, and Import/Update Vendors are about working with your Vendor company list data.

  • The functions on the right, Import/Update Product-Vendors and Export Product-Vendor Sample are about the Products that are associated with each of your Vendors.

  1. Export Vendor List: Go to Manage Catalog > Product Vendors > Export to download a CSV file of your Vendor data.
  2. To Import your Vendors, first download the sample data file by going to Manage Catalog > Product Vendors and click the Import/Update Vendors button on the left. Click the Export Sample File button to download the Excel file template.

    Next, after adding your data to the template, click on Import/Update Vendors and click to Upload Excel File.
    Image showing the Import Vendor functions on the Product Vendors page of the eTailPet system.
  3. To Import / Update the Products that are associated with your Vendors, first Export Product Vendor template for import (the templates in each are exactly the same):
    • This template includes a tab with a list of the vendors associated with each product: Manage Catalog > Product Vendors > Import/Update Product-Vendors > Export Sample File.
    • This template includes a tab with current vendors associated with each product and the unit cost: Manage Catalog > Product Vendors > Import/Update Product Vendors > Export Product Vendor Sample.
    To Import products associated with your vendors and vendor unit costs: Go to Manage Catalog > Product Vendors > Import/Update Product-Vendors > Upload Excel File.
Product Vendors
Quantity on Hand Product Inventory

Image showing the Import Product Inventory functions on the My Products page of the eTailPet system.

To Import Product Inventory, first Export the template for import: Go to Manage Catalog > My Products > Import Product Inventory > Export Sample File.

To Import and Update Public Products Inventory: Go to Manage Catalog > My Products > Import Product Inventory > Upload Excel File.
Image showing the Import Product Inventory functions on the My Products page of the eTailPet system.
Importing and Updating Inventory
Purchase Orders

Image showing the Import / Export functions on a Purchase Order in the eTailPet system.

To import items into a PO, first Export Purchase Order template for import: Go to Manage Catalog > POs > Open PO > Import Items > Export Sample File.

Image showing the Import functions on a Purchase Order in the eTailPet system.

Then Import the Purchase Order template: Manage Catalog > POs > Open PO > Import Items > Upload Excel File.

To Export the Items from a PO, from an open PO, click the Export button and you will download an Excel file of the PO details, including all Items.

The Purchase Order Process

 

 

Frequently Asked Questions

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.

Need Help?

Can't quite find the answer you're looking for? Our support team is just a call away.