All Collections
Education
How to Interpret Our Supplier XLS File
How to Interpret Our Supplier XLS File

How to use the supplier XLS file.

Joshua Schroy avatar
Written by Joshua Schroy
Updated over a week ago

We appreciate your interest in becoming a Zendrop Supplier! We tried to make it as simple as possible for you to add your products to Zendrop, and this bulk import feature is definitely the quickest way to do it. That being said, you may have some questions about the file. We're here to help! In this article, we'll go through the bulk import file and show which fields correlate to which items on the page for the product listing. Below is an example of a product listing on Zendrop, through Zendrop Fulfillment.

Keep in mind that currently we only support onboarding US Suppliers that ship to the US. Even if you do support shipping to other countries, we won't be able to facilitate those transactions until a future date. Most of the market for dropshippers is for US distributors shipping to customers in the US with fast shipping times. Zendrop Fulfillment also offers many different shipping methods and options from our warehouses in China. As a Zendrop Seller shipping from the US, you will only have one option for the time being; shipping to the US with Regular Shipping. The shipping rate and speed will be determined by you, and will impact how sellers interact with your listing(s).

XLS File:

  • 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 NOTE: When a user selects the "Variants" tab on the product listing, the following information will be displayed. As you can see by the screenshot above, exactly how you display the text in the XLS file is how the text will be displayed on the product listing (capitalization, grammar, etc.).

  • 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, please enter the amount of inventory you currently have 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.

Keep in mind that 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.

Did this answer your question?