Skip to main content

How to Interpret Our Supplier XLS File

How to use the supplier XLS file.

The Zendrop supplier bulk import file is the fastest way to add products to the platform. Each column maps directly to a field on your product listing. Below is a breakdown of every column, with a screenshot of how it appears on the listing page.

Zendrop currently supports U.S. suppliers shipping to the U.S. only. You'll have one shipping option available: Regular Shipping to the U.S. Your shipping rate and speed are set by you, and both affect how sellers interact with your listing.

XLS file fields

  • Product Title:

    • This is the large text to the right of the Hero Image above the supplier name.

  • Description (HTML/TEXT):

    • This is the smaller text underneath the supplier name.

  • Published (YES/N):

    • This information does not show up on the product listing, it simply determines whether or not the product listing will be live and published on our app.

Important: When a user selects the "Variants" tab on the product listing, the following information will be displayed. Exactly how you display the text in the XLS file is how the text will be displayed on the product listing (capitalization, grammar.

  • Size:

    • If your product comes in different sizes, you'll need to list each size as a different row in the file, with the same hero product information (this can be easily copied and pasted into a new row).

  • Color:

    • If your product comes in different colors, you'll need to list each color as a different row in the file with the same hero product information (this can be easily copied / pasted into a new row).

  • SKU:

    • You can use the SKU that your products have in your database if that's easier for you to manage inventory. You can also leave this column blank if you'd like, and a new Zendrop SKU will automatically be generated for you.

  • Inventory:

    • If you hold inventory of this product, enter the current inventory count for this product. We can manually update inventory later on. If you leave this column blank, we will automatically add 1,000,000 units of inventory for this product. Keep in mind, that if a Zendrop seller sells a product and you do not have accurate inventory listed on Zendrop and are out of stock, they'll be much less likely to order from you in the future.

  • Price (USD):

    • This is the wholesale price that you want to be paid per unit. The price will appear under the "cost" column in the above screenshot.

  • Product Images (Comma Separated):

    • The other product images underneath the hero image for the product in the first screenshot.

  • Variant Image:

    • These are the specific images displayed as the hero image for each variant in the second screenshot, under the "Variants" tab.

  • Processing Time:

    • The window of time in days of how long it takes you to process an order.

  • USA - Delivery Time:

    • This is displayed on the product listing for the Zendrop seller to communicate to their customers about expected delivery times.

  • USA - Shipping Cost (USD):

    • We need a flat rate shipping cost per variant. We suggest using the more expensive shipping zones so you don't take a loss on any orders. If you want to be more competitive, you can do analysis of where orders typically ship to and how much they cost, and use that average to calculate a flat rate shipping price you want to charge per variant.

There are two different visibility options for your product listings. You can either have the product visible to all Zendrop sellers or you can hide the listing from the platform allowing you to only share the private URL with those that you want to see the listing.

Upload your XLS file and start reaching Zendrop sellers today.

Did this answer your question?