Category Archives: Exporting Data

The Freedom To Control Your Own Data


Every month, DistributorCentral receives the most online product data traffic of any service provider in the industry. There is a reason we’re #1, we generate more than 6 million product views for our suppliers every 30 days from the DC research tool, 8,000 e-commerce distributor websites, and our live product data feed used by other providers such as commonsku, PromoCorner, and Web Jaguar.

 

Our mission at DistributorCentral is to be the most accurate solution in the industry; for an end user to accurately order products from a distributor’s website, and for the distributor to create accurate orders to the supplier.

Accurate orders all start with accurate and complete product information from the supplier. Suppliers using DC agree to honor their products and prices listed so distributors are assured of having accurate data without having to verify during the selling process.

“The Suppliers that I work with find DistributorCentral to be the easiest system to update, export, and import data for shopping cart functionality and accuracy. Our Distributors and Suppliers work as a team to ensure accuracy and report inaccuracies when they are noticed. When a Distributor finds a discrepancy, they have a tool to quickly make a comment and send that over to DistributorCentral. Once received, the Supplier is made aware and is able to correct the item via their Supplier representative,” said Aubrey Weaver, Senior Account Manager.

DistributorCentral allows suppliers total access to their products and pricing. The Product Editor has been designed for ease of use to make real-time updates. Suppliers can also export product, option and choice data into an excel format to update and upload. “From the time the updates are received and started, we are able to complete the import in just a matter of minutes,” said Heather Windler, Support Specialist. Most suppliers only need to export their product data though for annual pricing update purposes.

Besides hosting product data and pricing, we have also been working with suppliers to help them be able to share inventory data electronically. This is another way how we are committed to providing enhanced technology and integration solutions that in turn, support our mission.

Suppliers – Control your own Data on DC with spreadsheet exports and uploads.

Did you know that you can export and upload your DC spreadsheet and /or images for importing back into your Product Database from your own DC account? Then you can track that update and you will be notified upon the completion of the product update.

Export your data: You can export your Product, Option and Choice data from your DC products. Most Suppliers only need to export their Products data though for pricing update purposes.

Go to Products Tab > Product Data Export > Excel Data Export

Once you click on Export, you will have the opportunity to export certain fields and criteria. Then “Submit” the file and you will receive an email with a link to download it for editing.

 

 

 

 

 

Upload your File: After you have edited your file and saved your changes, you can then upload it again for importing.

You can upload it under Shortcuts on the right side of the home page.

Once the file is uploaded, you can then track the upload and you will receive an email when we complete it.

Image Upload Requirements and Instructions:

Here are the steps / requirements to upload your product images to DistributorCentral to add to your product data:
1. Log into your Distributorcentral.com account. (If you have not received your login, ask your representative for that information)

2. Click on the link below

http://www.distributorcentral.com/home/issues_2.cfm?new=1&requesttypeguid=110D937A-A518-4444-A1DC-0140AE68AC8C&componenttypeguid=BC71A168-53A0-46E6-BB97-E4C73BAC6994

3. You will see a “Support Tracking” form. Use the images below to add in the information needed.
a. Enter “Your Email”
b. Under “Update Type” select Images
c. Under “Please Update” select Images and deselect all others
d. Upload your ZIPPED file of images by clicking on “Choose File” button.
e. Select “Upload” button and wait for the file to completely upload
f. When done uploading “Save”

Image Requirements as follows:
Image Size:  Minimum- 500 x 500 dpi – Maximum 750 x 750 dpi
Resolution:  72 dpi for online viewing
Mode:  RGB Mode for online viewing
File: must be a jpeg file and must be named according to the item # in DC to be associated correctly.

NOTE:DC system will downsize your large images for the Medium and thumbnail size automatically

Learn more about exporting your data for other service providers: http://blog.distributorcentral.com/2010/12/03/exporting-contact-information-for-other-service-providers/

Once you have your data imported, make them display with this guide: http://www.distributorcentral.com/resources/education/guides/ProductCompletionGuide.pdf

Reports for Suppliers- Summary of Marketing Reports- New Reports added!

Here is a summary of some reports with really great marketing data available to all DistributorCentral Suppliers:

ROI Report” (Emailed Monthly and is available at the top right of your DC account)

This is a Summary of the reports that I mentioned above and includes a bit more information.

New Distributors by Month” (ROI Report- Emailed each month)

List of all new DistributorCentral Distributors for the given month.

Supplier – Viewed Items by Distributor”  (Reports Menu, scroll down ¾ of the way)

This report tells you what Distributors haved viewed your products in a given time frame. This includes if it was viewed on the website or in their DC account.

Products Added to Cart” (Reports Menu)

This report shows what products have been added to a cart either on the Distributor websites or in a Distributor account for a certain date range

Product Traffic Across DistributorCentral” (Reports Menu)

Shows your most viewed products across the entire DistributorCentral system. On Distributor websites and in Distributor accounts for a certain date range.

Product Requests” (Reports Menu)

This Report gives you a summary of all your product requests made by Distributors through the DC system in a date range

Top Keywords & Categories” (Home Page under Shortcuts)

Gives you a full list of the most searched categories and keywords in DistributorCentral and on Distributor websites.

Distributor Activity on DC” (Home Page under Shortcuts)

Lists all Distributors that have logged into their DC account in the last 90 days. Click on the Distributor name to get more information about them including contact information.

Email any questions to suppliers@distributorcentral.com.

Compare Pricing On Products Copied From Suppliers

Attention Fulfillment Account users…

We have added a quick compare page for products that you have added into your Fulfillment Account using the “Add Similar From Supplier Product”  link. This will make it easy for you to compare the pricing of your Fulfillment products to the Supplier’s current pricing in DistributorCentral, where you can then update the price if necessary.

To access this tool, login to your Fulfillment Account, and then go to the Products menu >> Advanced Features >> Compare pricing On Products Copied From Suppliers. See image below. Click here to learn more about our Fulfillment Account feature.

RSS feeds for Product Information

DistributorCentral offers this RSS feed below which will keep you up to date on all the product additions to the DC system. This is another way that DC is offering more product data in one place!

New Products / Removed Products:

http://www.distributorcentral.com/home/product_changes.cfm?rss

Just Subscribe to this feed (see the image below)

If you are in Internet Explorer, you can save this feed to your Favorites and come back to it when you want to see the newly added products.

You can also access this from inside your DistributorCentral account:

1. Log into your DC account

2. On the home page, go to the right side, under “Shortcuts

3. Click on “Product Addtions/Deletions” link to view the list of products.

The list looks like this in your DC account:

Exporting Product Information for other Service Providers

Suppliers, did you know that you can export the product information that you have entered into DistributorCentral and send it to your other service providers? This is one way we are helping you maintain product information in one place!

This eliminates the need for double entry of your information. Just enter your products once into DistributorCentral and you will not need to spend any more time and labor on this again for other providers.

Here is how you export your product information:

1. Log into your DC account and hover over “Product Data Export” Menu and click on “Excel Data Export”

2. The next screen you will see is this one below:

Here you will select the “Additional Fields” that you want to include in your export, double check your Email address to send the file to and select “Save File

Now you will receive an email with a link to download this file from DC.

This spreadsheet will include all of your product information. You can also export your Option and Choice information to send to Service Providers if needed by going to “Products” Menu and Add/Edit Options or Add/Edit Choices.

[youtube=http://www.youtube.com/watch?v=nfvwGZLWrP0&fs=1&hl=en_US&rel=0&hd=1]

Exporting Contact Information for Outlook

You can export your Customers from your DistributorCentral database to import into your Outlook software if needed. You can also import contacts to your DistributorCentral account. This report makes your Customer data available for any other software that allows import as well.

To export Customers from DistributorCentral:

1. Once logged into your DistributorCentral account, click on Reports Tab

2. Here, find the “Customer List” report and click on it.

3. Now select the fields that you would like to include in your report and select “Submit” at the bottom.

(if you are exporting for your email program, you will only need the basic fields like Name, Email, Address)

4. Select “View” to the right of the report that you just created

5. Now you can change your parameters at the top of the page.

First set your start and end date to pull your customers

Then set the contact type (usually the main contact)

Then Select “yes” for Active accounts

6. Now select “View Report”

7.  Now you can export the report in csv format by selecting csv from the format drop down and select “Export” to save it to your computer

8. Now go to your Outlook software and select “File > Import/Export” to import your contacts to your Outlook Software.

To Import Customers to DistributorCentral:

Distributors can send their customer lists to info@distributorcentral.com along with the account number to import the customers. DC can bulk import those contacts for you.

The excel file that you send should include these fields in different columns which are clearly defined:
Customer name
Email
Street address
City
State
Zip
Phone

Exporting Order Information for QuickBooks

Distributors – Did you know that you can export your Orders & Invoices to Quickbooks from your DistributorCentral Order System?

This feature eliminates the need for double entry from DC to your QuickBooks system.

Exporting Purchase Orders & Invoices to QuickBooks

Create and Save your QuickBooks Import File:

1. After logging in to your account, click on the Orders tab, and then on the QuickBooks Download link.

2. Choose whether you are going to create an import file for invoices to your customers or purchase orders to your suppliers.

3. Select the dates for which that you would like to download transactions – *Note – please limit your download file to one month of data at a time. Also, note that if you try to import a file into QuickBooks that contains an invoice or purchase order that was contained in a previously imported file, QuickBooks will not import that transaction again.

4. Choose whether or not you intend to print the invoices or purchase orders from QuickBooks. If you have sent your purchase orders or invoices electronically from DistributorCentral, or you have printed a version from DistributorCentral and sent those to your customers or suppliers, you can choose “No” for this question. Otherwise, if you intend to send the invoice or purchase order after importing it into QuickBooks, select “Yes”.

5.If you have specific accounts setup in your QuickBooks file with which you would like to associate the transactions, specify them in the Accounts fields. For invoices, the defaults are ACCOUNTS RECEIVABLE for the accounts receivable account, SALES for the line items, and SALES TAX PAYABLE for the sales tax account. For purchase orders, the defaults are PURCHASE ORDERS for the accounts payable account and SALES INCOME for the line items.

6. Once you are satisfied with your selections, click Submit.

7. When the import file is generated, you can click on the QuickBooks link to view the file, or “right-click” on the link and choose “Save Target As”, choose the appropriate location on your hard drive to save the file (default file names are generally in the format youraccountno_mm_yyyy_InvoicesORPOs_downloaddate.iif (eg. 100006_Feb_2004_Invoices_03-Feb-04.iif).

Import the file into QuickBooks:

1.Once you have saved the import file, open your QuickBooks file, choose File -> Utilities -> Import -> Import IIF Files.

2.Browse to the location on your hard drive where you saved the import file when you downloaded it from DistributorCentral.

3.Once you have found the file, click “Open”.

4.At this point, your data has been imported into QuickBooks. If you choose “yes” for the “Print from QuickBooks” question when you downloaded the file from DistributorCentral, you should see the list of invoices and/or purchase orders to print in your “reminders” list if you have setup your QuickBooks file this way.

5.From this view, you can edit the order, which allows you to can add options, edit pricing, change color choices, etc.
You can now run reports or print your documents from QuickBooks.

Important points to note
-If the Customer or Vendor names exported from DistributorCentral do not match those that have been setup in your QuickBooks file, they will be added to your Customer and Vendor lists as new records.

-The accounts to which the transactions are posted must match those in your QuickBooks setup; if you choose to specify your own account names, please be aware that if those accounts do not exist in your QuickBooks file they will be created.

-Avoid importing duplicate transactions into QuickBooks by deleting your old import files, or moving them to a different location on your hard drive.

-DistributorCentral’s application creates ePSA-compatible purchase orders and invoices; the data included in DistributorCentral’s transactions is significantly more complex than that allowed in a QuickBooks import file. As such, your purchase orders and invoices in QuickBooks will not have the same level of detail as those created by DistributorCentral. As such, we highly recommend using DistributorCentral’s powerful purchase order and invoice tools for your business needs; DistributorCentral cannot be responsible for or support any errors arising from the importing of data into QuickBooks.

-For additional help, hints, or support for QuickBooks please see http://www.quickbooks.com/support/sindex.html.