CSV _ XLSX File


How To Connect

Info
Our native CSV/XLSX file based integrations allow you to easily generate and update file based connections with minimal setup.

If your channel, business, or partner, needs a routinely updated data sheet for your product data, this is the best way to manage these files through Flxpoint.


Types of Integration

CSV/XLSX files can be delivered in a variety of ways.

  • via FTP/SFTP
  • via Email
  • via Download from HTTP link

The authentication for these will vary depending on the mechanism you are using to retrieve and/or provide files. These authentication methods are covered in the video above.

  • HTTP does not need authentication; we will generate the file and URL for you inside of our system.

Listing Operations

Link Listings

NOT SUPPORTED

The feature is not currently available with CSV/XLSX integration processes.


Sync Listings

SUPPORTED

Sync Listings will update your existing channel listings through your selected method. (Email/Http/Ftp/etc)

Limitations:

A listing must be Published before a Sync Listings operation will update any information. If the listing is not currently in a Listed status, the item will fail to update.


Publish Listings

SUPPORTED

This will publish any listing variants that are queued to publish. Depending on your mapping template, it will publish the configured fields in a file format based on your channel configuration.

Examples
If you have configured an Email based channel, we will send you a file as an attachment on an email.

If you are an FTP based channel, we will post a file to the configured FTP.

If you are using an HTTP based channel, we will produce a URL inside of our tool for you to use.

If you are using a Manual File type, you will be provided a download link inside of Flxpoint.


Order Operations

Get Orders

SUPPORTED

This will get any new orders from the configured connection that have not yet been imported to go through the fulfilment process.

This operation retrieves orders from the configured connection. For example, if there are no files present on an FTP, or on a Google Sheet, we will not be able to import that order file.

My Orders are not importing, what should I do?

The most likely cause of this issue relates to the order status on your store, and the order status we're looking for based on our configurations. If you are unsuccessful at importing an order; double check the status of the order, and ensure it matches your configurations for this operation.

The second possibility is that the order is "too old" for us to import. Under "Configure Settings" you also have the option of selecting the date range of orders we can import. If you set this limit to 7 days, consider checking the non-imported orders creation date and increasing the number under the "Get Orders Created within the last X Days" configuration.


Sync Orders

SUPPORTED

Sync Orders will update an existing Fulfillment Requests with shipment information. This includes Carrier, Method, Tracking information, shipped-SKU information, and shipped quantity.

Specifically, this will sync back components like tracking information, shipping information and carrier information.