[Add System Name to Title]

[Add Logo here]

Overall Assessment: X

  1. Data Spec - Can we obtain the necessary data for our CSV FTP solution?
    1. Products
Required Column Name Available? Field
erp_product_id
pack_type
name
active
is_catchweight
pack_price
Price_per_weight_unit
Required for catchweight products
pack_items_count
Weight
Required for catchweight products
Stock_level
(unless is_unlimited_inventory)
store_key
  1. Price Tiers
Required Column Name Available? Field
erp_tier_id
tier_name
erp_product_id
pack_type
quantity
price
catchweight_price
  1. Customers
Required Column Name Available? Field
erp_customer_id
restaurant_name
address
city
state
zipcode
is_checkout_enabled
  1. Data Mapping
    1. Does the software offer data mapping capabilities? (Meaning that data from their platform in column X can be written into the file under the column name Y)
    2. If not, we need to investigate other solutions i.e. Fiver, MS spreadsheet workaround solutions to translate data from X format to Y format
  2. File Format - Can files be exported in CSV? If not, what is the file format? Ideal format is csv but other formats can be useable as long as we can transfer it into csv
  3. File Path
    1. Do they have API or file exchange capabilities?
    2. If yes, are they able to transfer files to a remote directory?