Blog

Drop Shipping & eCommerce Blog | Doba

The Data Export Tool: A powerful feature available to all Doba retailers

Written by Doba on May 23, 2014 in Doba Features and Policies

dataexport

Overview of the Data Export Tool

The Data Export tool is a powerful downloading tool. It allows you to export custom sets of product information from Doba’s database. The main purpose is to help you quickly populate a website with products to sell. There are also many other handy uses for this tool. The Data Export tool is accessible through the Feed, Catalog, Inventory, and Data Export tabs! This feature will also allow you to download product or inventory data very quickly. Some uses include product comparison, listing, product and inventory management and reporting. Additionally, you can download the product information in formats such as .csv (spreadsheet), .tab, and .xml.

The essential steps in using the Data Export Tool

 

• First, identify items you wish to sell. Add those items to an Inventory List. Once you have all of those items added to an Inventory List, you can begin using the Data Export Tool.

 

 

my inventory page

• Second, Click on the "My Inventory" tab on your Doba account you will find your Inventory Lists. Select all items in your inventory list(s). Then select the purple “Data Export” button.

 

data export popup

 

• Third, Click on the “Data Export” button and a pop-up prompts you to select a format. After selecting the format of your choice, download the file to your computer. You can either "Download and Save" or “Download Only.”

 

doba data export csv example

File formats available for the Export

Formats available:

Doba Product Comma Delimited - Spreadsheet format (.csv) that gives you all of the product information (46 headers/values for each item)

Doba Product Tab Delimited - Text or Spreadsheet format (.tab) that gives you all of the product information (46 headers/values for each item)

Doba Product XML - Extensible Markup Language Format (.xml)--essentially an internet code (46 headers/values for each item)

Doba Inventory Comma Delimited - Spreadsheet format (.csv) including item ID, shipping cost, wholesale price, and available quantity (only 7 headers/values for each item)

Doba Inventory Tab Delimited - Text format (.txt) including item ID, shipping cost, wholesale price, and available quantity (only 7 headers/values for each item)

Doba Inventory XML - Extensible Markup Language Format (.xml) including item ID, shipping cost, wholesale price, and available quantity (only 7 headers/values for each item)

Custom Formats:

custom export formats

Begin listing products by using one of the “Product" formats. To update inventory and pricing, download the same Inventory Lists in one of the “Inventory" formats and upload it to the respective site. You can effectively manage your product listings and inventory using this tool!

Other Applications of the Data Export Tool

If you wanted to list many items on a website such as Amazon.com, what would be the quickest way? Copying and pasting information, going back and forth between Doba and that site would be would be extremely time consuming. This is where the Data Export tool can help! Create a spreadsheet (Product Comma Delimited format or a custom data export) of all of the items you would like to sell with the help of the Data Export tool. You can view and compare your fields between your spreadsheet and your site or account making sure it’s correct. Load the products on to your site or account. Then, move on to the next products you would like to list and sell!

How would you check your potential profit margins on the items you would like to sell? You can download an Inventory List in the Doba Product Comma Delimited format to create a spreadsheet. You can look at columns AA (Manufacturer's Authorized Price or MAP), AB (Wholesale Price), AD (Wholesale Price if you pay with Prepay), and AF (Manufacturer's Suggested Retail Price or MSRP) and decide what you want to sell the item for. *If the item has a MAP, you must sell the item at or above that price. You can check what profit you could make between the MAP and the wholesale price. You could also check the difference between the MSRP and the wholesale price.

Some retailers want a physical, palpable product catalog. Although Doba does not print and mail out a product catalog, you could use the Data Export tool in that creation process. Creating a custom product catalog could begin with downloading an Inventory List in a spreadsheet format (perhaps Doba Product Comma Delimited) and then formatting it in Excel or a similar program. Print the final product and start distributing your custom product catalog.

Get blog updates sent straight to your inbox

Recent Posts