You can export order data from any of your Open, Submitted, or Delivered Orders. You can also import an order into Shop.

First, you'll need to select the order you want to export. Simply click on any order from your Orders Tab.
​

To export an open order that has not yet been submitted, click on the open order.

Clicking an open order will take you to the Cart. In the Cart, you'll see the Export option at the top.

Once you select Export, you'll be given the option to name your file. By default, it will be named the same as your order. The character limit for the order name is 100 characters.

The Order can be exported in either a CSV file format, a Food Trak compatible file, a CBORD compatible file, or a Computrition compatible file.

You also have the option to include pricing information. Pricing will show up to 3 decimal places for catch-weight items.

Once you click Export, you'll see confirmation that your export was successful.

If a delivery date has not been selected for the order, the delivery date will show as Not Set in the download file.

Now, let's walk through exporting an order that has already been submitted.

First, click on the historical order. Then, select the Export icon.

Once you select Export, you'll be given the option to name your file. By default, it will be named the same as your order. The character limit for the order name is 100 characters.

The Order can be exported in either a CSV file format, a Food Trak compatible file, a CBORD compatible file, or a Computrition compatible file.

You also have the option to include pricing information. Pricing will show up to 3 decimal places for catch-weight items.

To Import an order, you will need to navigate to the Orders Page.

The Import button is on the top right of your screen. Once you select Import, the import modal will populate.

The first field is a Format drop-down. This will allow you to select either a CSV file, a Food-Trak compatible file, a CBORD compatible file, or a Computrition compatible file.

If you select the CSV, Import/Export Format, the .csv (Comma delimited) file must be formatted correctly before importing the order into Sysco Shop. Only four columns—A, B, C, and D —are required.

Rows that will be imported in Column A should contain a capital “P” (for "Product"). Column B should always contain the item’s SUPC number. Column C will be the case quantity for that item. Additionally, you can add the OpSite number to the top of Column C. Column D will be the split/each quantity for that item. Column D is where you can put the account number at the top.

If you want to add a delivery date to your imported order, add your future date at the top of Column F. If it is a past delivery date, is invalid, or isn’t specified, Shop will automatically assign your next default delivery date to the order. This can be modified once the order has been imported.

Once you've selected the format, you'll be prompted to choose a file from your computer. Select Browse to locate the file on your device.

To skip over any items on your file that don't have a quantity value entered, use the toggle to Skip empty quantity line items.

Click Import to import your order into Shop.

Once the order has been imported, it will be your Active order on the Orders Page.

Related articles linked below. Click here to view our entire Help Center.