We have made some new additions to our Export Mapping Tool.
For Orders:
- You can now use two new placeholders #?CurrentTimeStamp?# (with format MM/DD/YYYY hh:mm:tt) and #?CurrentTimeStampDateOnly?# (with format MM/DD/YYYY).
- Map bvc_Package.WeightLbs to export the order package weight in lbs, as opposed to the existing column bvc_Package.Weight which exports in ounces.
For Products, we have added support for WFS Inventory fields:
- QtySoldInfo.QtySoldWFS30 – exports number of sold units in the previous 30 days.
- AggregatePhysicalQtyWFS – exports total WFS units.
- AggregatePhysicalQtyWFSSellable – exports current sellable WFS units.
- WFSInTransitQty – exports WFS In Transit units.
- WFSAvailableQty – exports total units in stock and In Transit.