To create new items, simply create a csv file with the following columns:
- id
- client_id - Your Client ID is a unique 18 digit number provided during onboarding. It can be located in the URL of your client portal link
- name (Required field) - The description of the item as printed exactly on all tags or barcodes. Descriptions should be as specific as possible. <= 100 characters
- short_name = A short name for the item <= 50 characters
- upc (Required field)- Must be an exact match to the physical barcode printed on the product as well as the readable data when scanned. *UPCs cannot be updated once the item is created in the Mochila Catalog*)
- used_upc -UPC for a used variant of this item
- sku (Required field) -The SKU of the item.
- product_code - string used to group together similar (but not exact) items. Example - The same style of pants in various sizes would all have the same product code.
- nmfc_code - nmfc code is a standard that provides a comparison of commodities moving in interstate, intrastate and foreign commerce.
- category -Informational only, e.g. "Apparel", "Footwear". Used for rolling up data for reporting/data analysis
- subcategory - Informational only, e.g. "Apparel", "Footwear". Used for rolling up data for reporting/data analysis
- is_package
- requires_expiration -
- requires_serial_number
- serial_number_validator
- hazmat
- ships_in_own_container
- customs_value
- length
- width
- height
- weight
- value
- tariff_code
- customs_origin
- customs_description
- is_composite
Value Definition 0 Single Unit (individual units or eaches) 1 Casepack. Cases may be automatically converted to eaches for fulfilling orders 2 Virtual Bundle (a UPC that is converted to multiple UPCs for fulfiling orders) 3 Kits composed of multiple UPCs
- item_value (value to be used for duties and taxes calculation on exports)
- short_name (please leave blank - used for internal Mochila systems)
- is_package (0 = unit of sellable inventory; 1 = branded box)
- tariff_code (Harmonized Tariff Code, to be used to populate the commercial invoice for export shipments)
- customs_description (to be used to populate the commercial invoice for export shipments)
- customs_origin (to be used to populate the commercial invoice for export shipments - two letter country code abbreviation for the country of manufacture)
Use each row to describe the item you would like to create.
The following is an example item:
| client_id | sku | upc | item_name | hazmat | sioc | width | length | height | weight |
| 12345678910 | ABC-123 | 080102030405 | Baseball Bat | 0 | 0 | 4 | 20 | 4 | 7.8 |
| product_code | is_composite | item_value | category | subcategory | is_package |
| ABC | 0 | 10 | Sporting Goods | Baseball | 0 |
| tariff_code | customs_description | customs_origin |
| 9506.99.9000 | baseball made of leather and plastic | CN |
Please use the Excel template file below to notify Mochila of new items. Once the file is complete, email the file to help@mochilafulfillment.com. Mochila will review your file and create the items within 1 - 2 business days.