ZPL Replacement fields

Item Replacement Fields

{items.name}

{items.category_id}

{items.type}

{items.type_name}

{items.supplier_id}

{items.manufacturer_id}

{items.manufacturer_name}

{items.manufacturer_part_number}

{items.manufacturer_logo}

{items.brand_name}

{items.importer_id}

{items.item_number}

{items.product_id}

{items.quantity}

{items.ecommerce_product_id}

{items.ecommerce_product_quantity}

{items.description}

{items.model_number}

{items.size}

{items.tax_included}

{items.cost_code}

{items_serial_numbers.cost_code}

{items.cost_price}

{items.unit_price}

{items.consignment_cost_percent}

{items.consignment_fee}

{items.promo_price}

{items.start_date}

{items.end_date}

{items.price_percent_of_subtotal}

{items.reorder_level}

{items.expire_days}

{items.item_id}

{items.allow_alt_description}

{items.is_serialized}

{items.override_default_tax}

{items.is_ecommerce}

{items.is_service}

{items.commission_percent}

{items.commission_percent_type}

{items.commission_fixed}

{items.change_cost_price}

{items.disable_loyalty}

{items.deleted}

{items.last_modified}

{items.ecommerce_last_modified}

{items.tax_class_id}

{items.replenish_level}

{items.system_item}

{items.max_discount_percent}

{items.max_edit_price}

{items.min_edit_price}

{CALIBER:item_attribute_value}

{ACTION:item_attribute_value}

{items.custom_field_1_value}

{items.custom_field_2_value}

{items.custom_field_3_value}

{items.custom_field_4_value}

{items.custom_field_5_value}

{items.custom_field_6_value}

{items.custom_field_7_value}

{items.custom_field_8_value}

{items.custom_field_9_value}

{items.custom_field_10_value}

{items.required_age}

{items.verify_age}

{items.weight}

{items.length}

{items.width}

{items.height}

{items.ecommerce_shipping_class_id}

{items.long_description}

{items.allow_price_override_regardless_of_permissions}

{items.main_image_id}

{items.only_integer}

{items.is_series_package}

{items.series_quantity}

{items.series_days_to_use_within}

{items.is_barcoded}

{items.accounting_id}

{items.is_used}

{items.used}

{items.exclude_from_profit_report}

{location_items.location} (this is the field that is used to store the bin of an item)

{location_items.cost_price} (good to use for multi locations that have different cost/pricing at different stores)

{location_items.unit_price}

{location_items.promo_price}

{location_items.start_date}

{location_items.end_date}

{location_items.quantity}

{location_items.quantity_on_order}

{location_items.quantity_committed}

{location_items.reorder_level}

{location_items.replenish_level}

{location_items.override_default_tax}

{items.used_item_number} (you can include this and the regular item number replacement field in the same line of code so long as the you don't use both fields.

Item Kit Replacement Fields

{item_kits.item_kit_id}

{item_kits.item_kit_number}

{item_kits.product_id}

{item_kits.name}

{item_kits.description}

{item_kits.unit_price}

{item_kits.custom_field_1_value}

{item_kits.custom_field_2_value}

{item_kits.custom_field_3_value}

{item_kits.custom_field_4_value}

{item_kits.custom_field_5_value}

{item_kits.custom_field_6_value}

{item_kits.custom_field_7_value}

{item_kits.custom_field_8_value}

{item_kits.custom_field_9_value}

{item_kits.custom_field_10_value}

Bound Book Replacement Fields

{boundbook.id}

{boundbook.location_id}

{boundbook.boundbook_id}

{boundbook.boundbook_book_id}

{boundbook.custom_field_1_value}

{boundbook.custom_field_2_value}

{boundbook.custom_field_3_value}

{boundbook.custom_field_4_value}

{boundbook.custom_field_5_value}

{boundbook.custom_field_6_value}

{boundbook.custom_field_7_value}

{boundbook.custom_field_8_value}

{boundbook.custom_field_9_value}

{boundbook.custom_field_10_value}

{boundbook.serial_number}

{boundbook.product_id}

{boundbook.manufacturer_name}

{boundbook.manufacturer_number}

{boundbook.importer_name}

{boundbook.item_id}

{boundbook.item_number} (UPC)

{boundbook.model_number}

{boundbook.item_description}

{boundbook.gun_type}

{boundbook.caliber}

{boundbook.action}

{boundbook.choke}

{boundbook.barrel}

{boundbook.finish}

{boundbook.in_stock}

{boundbook.used}

{boundbook.pending_disposition}

{boundbook.disposed}

{boundbook.acquire_date}

{boundbook.acquire_cost}

{boundbook.acquire_retail_price}

{boundbook.acquire_individual}

{boundbook.acquire_invoice}

{boundbook.acquire_ffl_number}

{boundbook.acquire_ffl_expires}

{boundbook.acquire_license_type}

{boundbook.acquire_drivers_license}

{boundbook.acquire_drivers_license_state}

{boundbook.acquire_drivers_license_issued}

{boundbook.acquire_drivers_license_expires}

{boundbook.acquire_companyName}

{boundbook.acquire_last}

{boundbook.acquire_first}

{boundbook.acquire_middle}

{boundbook.acquire_address}

{boundbook.acquire_address2}

{boundbook.acquire_city}

{boundbook.acquire_state}

{boundbook.acquire_zip}

{boundbook.acquire_county}

{boundbook.acquire_country}

{boundbook.acquire_phone}

{boundbook.acquire_phone2}

{boundbook.acquire_Email}

{boundbook.acquire_web}

{boundbook.acquire_notes}

{boundbook.acquire_source}

{boundbook.dispose_date}

{boundbook.dispose_solddate}

{boundbook.dispose_individual}

{boundbook.dispose_ffl_Number}

{boundbook.dispose_ffl_Expires}

{boundbook.dispose_nics}

{boundbook.dispose_nics_Date}

{boundbook.dispose_license}

{boundbook.dispose_license_state}

{boundbook.dispose_license_issued}

{boundbook.dispose_license_expires}

{boundbook.dispose_license_type}

{boundbook.dispose_state_id}

{boundbook.dispose_state_id_state}

{boundbook.dispose_state_id_issued}

{boundbook.dispose_state_id_expires}

{boundbook.dispose_birthDate}

{boundbook.dispose_race}

{boundbook.dispose_gender}

{boundbook.dispose_company_name}

{boundbook.dispose_last}

{boundbook.dispose_first}

{boundbook.dispose_middle}

{boundbook.dispose_address}

{boundbook.dispose_address2}

{boundbook.dispose_city}

{boundbook.dispose_state}

{boundbook.dispose_zip}

{boundbook.dispose_county}

{boundbook.dispose_country}

{boundbook.dispose_phone}

{boundbook.dispose_phone2}

{boundbook.dispose_email}

{boundbook.dispose_web}

{boundbook.dispose_4473_transaction}

{boundbook.dispose_price}

{boundbook.dispose_ssn}

{boundbook.dispose_birth_place}

{boundbook.dispose_weight}

{boundbook.dispose_height}

{boundbook.dispose_eye_color}

{boundbook.dispose_hair_color}

{boundbook.dispose_invoice}

{boundbook.dispose_notes}

{boundbook.edited}

{boundbook.edit_id}

{boundbook.edit_notes}

{boundbook.edit_fields}

{boundbook.lost}

{boundbook.stolen}

{boundbook.police_report}

{boundbook.police_report_date}

{boundbook.police_report_notes}

{boundbook.created}

{boundbook.last_modified}

{boundbook.created_by}

{boundbook.modified_by}

{boundbook.deleted}

{location_items.location} (this is the field that is used to store the bin of an item)

{location_items.cost_price} (good to use for multi locations that have different cost/pricing at different stores)

{location_items.unit_price}

{location_items.promo_price}

{location_items.start_date}

{location_items.end_date}

{location_items.quantity}

{location_items.quantity_on_order}

{location_items.quantity_committed}

{location_items.reorder_level}

{location_items.replenish_level}

{location_items.override_default_tax}

Customer Replacement Fields

{customers.id}

{customers.person_id}

{customers.company_name}

{customers.account_number}

{customers.credit_limit}

{customers.balance}

{customers.taxable}

{customers.tax_certificate}

{customers.custom_field_1_value}

{customers.custom_field_2_value}

{customers.custom_field_3_value}

{customers.custom_field_4_value}

{customers.custom_field_5_value}

{customers.custom_field_6_value}

{customers.custom_field_7_value}

{customers.custom_field_8_value}

{customers.custom_field_9_value}

{customers.custom_field_10_value}

{customers.ffl_number}

{customers.ffl_expiration}

{people.first_name}

{people.middle_name}

{people.last_name}

{people.full_name}

{people.title}

{people.phone_number}

{people.email}

{people.address_1}

{people.address_2}

{people.city}

{people.state}

{people.zip}

{people.country}

{people.birth_date}

{people.license}

{people.comments}

{people.ecommerce_contact_id}

Sales

{sales_items.serialnumber}

{sales_items.description}

{sales.sale_time}

{sales.sale_id}

Receiving

{receivings_items.item_unit_price}: Receiving cost

{cart_item.selling_price} Receiving selling price

Warehouse

{location_bin.bin_number}

Fulfillment 

{sales_deliveries.is_pickup}