coreSTORE - Labels: Direct Printing Replacement Fields
Replacement fields in coreSTORE are placeholders used in label printing to dynamically insert specific information about items, item kits, bound book records, and customers. These fields are enclosed in curly braces, e.g., {items.name}, and are replaced with the corresponding data during the printing process. They allow for customized and detailed labels by pulling relevant data directly from the coreSTORE database, ensuring accuracy and consistency across printed materials.
The list below are field names that can be used when printing labels. Item Kit fields can only be used when printing labels from the Item Kits screen and bound book labels can only be used when printing labels from the Bound Book screen.
{items.name}
{items.category_id}
{items.type}
{items.type_name}
{items.supplier_id}
{items.manufacturer_id}
{items.manufacturer_name}
{items.manufacturer_logo}
{items.manufacturer_logo_secondary}
{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}
{replacementfield,REPLACE,1,USED,NEW}
{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}
{boundbook.id} (the overall ID including all boundbooks)
{boundbook.location_id}
{boundbook.boundbook_id} ( the bound book ID for the record in the specific boundbook)
{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}
{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_items.serialnumber}
{sales_items.description}
{sales.sale_time}
{sales.sale_id}
{receivings_items.item_unit_price}
{location_bin.bin_number}
{sales_deliveries.is_pickup}
The list below are field names that can be used when printing labels. Item Kit fields can only be used when printing labels from the Item Kits screen and bound book labels can only be used when printing labels from the Bound Book screen.
Item Replacement Fields
{items.name}
{items.category_id}
{items.type}
{items.type_name}
{items.supplier_id}
{items.manufacturer_id}
{items.manufacturer_name}
{items.manufacturer_logo}
{items.manufacturer_logo_secondary}
{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}
{replacementfield,REPLACE,1,USED,NEW}
_**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} (the overall ID including all boundbooks)
{boundbook.location_id}
{boundbook.boundbook_id} ( the bound book ID for the record in the specific boundbook)
{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}
Warehouse
{location_bin.bin_number}
Fulfillment
{sales_deliveries.is_pickup}
Updated on: 06/26/2024
Thank you!