Announcement:Materials and articles for ProductCart 5 can be found at our brand new support center.

Create an account to edit articles | See Formatting Syntax for Wiki syntax | We look forward to your contribution!

Exporting Information from your Store

ProductCart allows you to export a variety of data from your e-commerce store, including products, categories, orders, sales, etc. In some cases, you can export the information in HTML, CSV, or MS Excel format. MS Excel will be shown as an available option only if ProductCart is able to successfully detect the presence of the application on the server. If MS Excel is not installed on the server, this option will be hidden (or a message will indicate that MS Excel does not appear to be installed).

Exporting Sales Data

ca To export predefined sales data follow these simple steps:

  • Select View Sales Reports from the Reports menu and click on Export Sales Data
  • Enter the “from” and “to” dates in the appropriate fields using the date format used on your store.
  • Indicate which date should be used (e.g. when the order was placed vs. when it was processed)
  • Then select the format in which you would like the data to be exported using the Export Format drop down menu. The choices are:
    • HTML table (the results are displayed in a browser page)
    • CSV format (a comma-delimited file that you can download)
    • MS Excel (if detected on the server)
  • Click on the submit button to generate the report.
  • If you opted for the CSV or Excel format, you will be shown a pop-up window with a link to download the file. To download the file, click on the download icon and choose a location on your computer in which to save the file. Or, right click on the download icon and choose Save Target As… from the context menu that will appear.

Custom Data Exports

In a custom data export you will be able to select which fields to export (unlike with the pre-defined sales data export mentioned above).

To perform a custom data exports select Custom Data Export from the Reports menu. In most cases, to generate an export file:

  • Format
    Select the format you would like the data to be exported in. The choices are: HTML table (the results are displayed in a browser page), CSV format (a comma-delimited file that you can download), or MS Excel. Remember that if MS Excel is not installed on the server, this option will be hidden (or a message will indicate that no MS Excel drives were found).
  • Date
    Enter a date range using the format used elsewhere on your store.
  • Order Date
    When you are exporting order related information, you can typically specify whether the system should use the date on which the order was placed, processed or shipped.
  • Order Status
    When you are exporting order information, you can also specify whether incomplete, canceled, and returned orders should be included in the report.

Click on the submit button to generate the report. If you are exporting to HTML, the information will be shown in your browser. Depending on the amount of data that you are exporting, it may take some time for the report to be generated.

If you are exporting to CSV or Excel, a file will be generated and saved to the server. The confirmation page will include a link to the file. If you receive an error message, this is often due to folder permissions not being properly set.

Unless otherwise specified, the file is saved to the “pcadmin” folder (which is typically renamed on a ProductCart-powered store). The folder must have “write” permission for the task to complete successfully.

Export orders

Virtually every field in the “orders” table can be exported using this tool. Please note that product information is consolidated in one field to allow the export to a 1-line record (e.g. 1 line in an Excel spreadsheet). Use the Export Products Ordered tool to export details on the products that were purchased.

Export products ordered

This feature allows you to export details on the products that were ordered within a specific date range. Each product that was purchased is a record in the export file. This means that an order can occupy multiple rows. If you need to recognize which products were ordered together, make sure to include the Order ID in the export file.

Export customer information

This feature allows you to export the information that is saved in the “customers” table, including the custom Fields that can be managed under Customers > Manage Special Fields.

Export affiliate information

This feature allows you to export basic information about the affiliate accounts in your store.

Export product and category information

You have two options:

  • Simple product export
    Use this feature to export some of the most commonly used fields. Do not use this feature if you have a large product catalog.
  • Advanced product export (Export for Re-Import Wizard)
    Use this feature to export more fields, and with larger catalogs. You will be able to search the products you wish to export (or divide the catalog into product ranges that are exported separately).
  • Advanced category export
    You can also export category information.

Please note the following:

  • Oversize
    Oversize settings are exported as an array of values separated by a double pipe sign “||”. The array contains the 3 dimension and the weight in ounces (or grams).
  • Category Assignments
    Category names are exported. If the product belongs to more than one category, category names are separated with a double star sign "**".
  • Removed/Deleted Product
    When you delete a product from the Control Panel, the product remains in the database not to compromise historical order data, and its “removed” status is turned on (i.e. the database field contains a ”-1”). You can export this piece of information by checking this field. Products that have a ”-1” as the value in the field are not currently shown in the Control Panel.

Creating a data feed for Google Base, Yahoo!, etc.

ProductCart contains tools that allow you to quick create a properly formatted data feed for popular Web sites where you can list your products.

Amazon

Understandably, several customers have asked about supporting the data feed to Amazon, but unfortunately it's not currently feasible: the data feed must be different depending on the category of product to be uploaded to Amazon. There are 23 categories. A store could very well have products that require a different data feed structure, which makes the creation of a data feed very problematic. On top of this, there is virtually no documentation on how the data feeds need to be structured and Amazon requires that you subscribe to their $39.99/month “Professional” plan to be able to upload your data feeds.

All in all, they've simply made it too hard to work with them. Hopefully they improve this program in the future and we can look at it again at that time.

ProductCart is a QuickBooks ready shopping cart

Export orders to QuickBooks

The ProductCart Synchronizer for use with QuickBooks provides two-way synchronization between your ProductCart-powered e-commerce store and your QuickBooks company file.

Export order to FedEx

Added in ProductCart v4.5, this export tool allows you to export orders in a format that can be imported into the FedEx Ship Manager. This allows you to more quickly process shipment in the Ship Manager and print FedEx shipping labels (including shipping to a thermal printer).

  • Order Date Rage: specify a date range (when the orders were placed)
  • Status: narrow the list of orders by order status (e.g. “Processed” orders only)
  • Shipping Date: the date these orders will be shipped (defaults to today)

:!: Feature limitation: overall order information is exported. If the order contained multiple packages, package-level information is not exported. You will have to divide up the shipment into multiple packages within the FedEx Ship Manager.


QR Code
QR Code Exporting Information from your Store (generated for current page)