Skip to main content

Exporting Serial Data

The Serial Data Export utility lets you export serial inventory to a spreadsheet for modifications and reimport via Serial Data Import.

To Export Serial Inventory​

  1. Go to Serial Inventory > Utilities > Serial Data Export.

  2. Enter selection criteria and click OK.

  1. The data opens in Excel. Make changes and save.

    info

    The export includes these fields:

    ModelCodeDescriptionCodeLocationCode
    CostStandardCostUniqueSellPriceTagPrice
    ReserveExclusiveCommentCodeL1L2Spiff
    SpiffEndDateFeaturesNotesSerial
    TypeAuditDateSerialTypeAuditNoteBrandCodeProductCode
    DateReceivedDaysSinceLastChangeBrandUserCodeProductUserCode
    ReserveExclusiveAvailableOriginalCostDiscount1
    Discount3Discount4Discount5Discount6
    Discount7Discount8Discount9Discount10
    BinLocationCodeDyeLot

  2. Import the data: Go to Serial Inventory > Utilities > Serial Data Import. Select file, map columns, click OK.

  3. Progress bar shows completion. Note shows records updated.

info

Previously known as "Unique Sell Price Import/Export". New fields added: Actual Cost, Discounts, Available, Unique Selling Price, Supplier and Notes. Writes Serial Audit Trail.

See Also​

Updated

March 16, 2022