Framework

tfb2

Overview

Store ID: tfb2
Store name: Framework
Retail title: —
Wholesale title: My Store Wholesale Catalog
Table set: —
Custom 1: —
Custom 2: 4
Last update: update2013-01-26

Store owner

Owner name: —
Owner email: —
Password hash: —
Password reset token: —
Password reset expires: —
Last login: —
Failed login attempts: 0
Lockout until: —

Storefront contact

Public info email: production@heroweb.com
Store address: FRAMEWORK ORDERS
Store phone 1: —
Store phone 2: —

Legacy auth

Admin password (legacy): set (hidden)
Save password (legacy): set (hidden)
Security question: —
Security answer: —

Email

Subject: Thank you for your order.
From: production@heroweb.com
Order confirmation message: —
Orders to: production@heroweb.com
Secure orders to: riverk@terrafirmabotanicals.com
Thank-you message: —
Email-a-friend thank-you: —
Email-a-friend message: —

Ordering

Keep orders: 1
Order info: —
Retail minimum: 0
Wholesale minimum: 0

Content & SEO

Meta description: —
Meta keywords: —
Homepage text: —
Global blurb 1: —
Global blurb 2: —
Global text 1: —
Global text 2: —
Proposal text: —
Tracking HTML: —

Catalog defaults

Category custom 1 heading

Custom 1

Category custom 2 heading

Custom 2

Category custom 3 heading

Custom 3

Category flag 1 heading

Special 1

Category flag 2 heading

Special 2

Category flag 3 heading

Special 3

Product custom 1 heading

Custom 1

Product custom 2 heading

Custom 2

Product custom 3 heading

Custom 3

Product custom 4 heading

Custom 4

Product flag 1 heading

—

Product flag 2 heading

—

Product flag 3 heading

—

Default list 1

Default list 2

Default list 3

Shop settings labels

Field	Label	Edit	List	Order
`store_pdf_note`	Store Pdf Note	Y	N	1
`international_ship_message`	International Ship Message	N	N	1
`continental_ship_message`	Continental Ship Message	N	N	1
`store_pdf_label`	Store Pdf Label	Y	N	1
`store_po_note`	Store Po Note	N	N	2
`wholesale_title`	Wholesale Title	N	N	3
`google_analytics_code`	Google Analytics Code	Y	N	3
`shipping_quote_text`	Shipping Quote Text	N	N	4
`google_category`	Google Category	N	N	5
`homepage_text`	Home Page Intro Text	N	N	5
`order_info`	Order Info	N	N	6.5
`shipping_notes`	Shipping Notes	N	N	7
`email_message`	Order Confirmation Message	N	N	10
`thankyou_message`	Order Thank you Page Text	N	N	11
`emailfriend_thankyou`	Tell a Friend Thankyou Message	N	N	12
`keep_orders`	Keep Orders	N	N	13
`emailfriend_message`	Tell a Friend email Message	N	N	13
`retail_title`	Default Page Title	Y	N	14
`meta_description`	Meta Description	Y	N	15
`meta_keywords`	Meta Keywords	Y	N	16
`store_custom1`	Default Keywords Phrases	N	N	19
`store_custom2`	Stylesheet Version #	Y	Y	20
`retail_min_order`	Minimum Order Amount	Y	N	21
`wholesale_min_order`	Wholesale Min Order	N	N	22
`global_blurb1`	Page Bottom Buttons	N	N	26
`global_blurb2`	Demo Home Page Img Map	N	N	27
`global_text1`	Back to MM Link	N	N	28
`global_text2`	Demo Home Link	N	N	29
`proposal_text`	Proposal Text	N	N	35
`date_time1`	Date Time1	N	N	36
`date_time2`	Date Time2	N	N	37
`date_time3`	Date Time3	N	N	38
`tracking_html`	Ad Tracking HTML	Y	N	46

Categories labels

Field	Label	Edit	List	Order
`embedded_insert`	Embedded Insert	N	N	1
`hide_cat`	Hide Category	Y	Y	1
`cat_caption_display`	Cat Caption Display	N	N	1
`cat_order`	Display Order	Y	Y	2
`cat_name`	Category Name	Y	Y	3
`doc_name`	Web Page Address	Y	N	4
`parent_id`	Parent Category	Y	N	5
`hide_heading`	Hide Category Heading	Y	N	6
`cat_flag1`	Cat Flag1	N	N	7
`cat_flag2`	Cat Flag2	N	N	8
`cat_flag3`	Cat Flag3	N	N	9
`cat_custom1`	Cat Custom1	N	N	10
`cat_custom2`	Cat Custom2	N	N	11
`cat_custom3`	Cat Custom3	N	N	11.5
`cat_glyphicon`	Cat Glyphicon	N	N	11.7
`cat_blurb1`	Description	Y	Y	12
`cat_blurb2`	Cat Blurb2	N	N	13
`cat_blurb3`	Cat Blurb3	N	N	14
`cat_image1`	Image	Y	Y	15
`cat_image2`	Heading Background Image	Y	N	16
`cat_image3`	Cat Image3	N	N	17
`top_nav_flag`	Show in Main Nav	Y	N	18
`cat_nav2_flag`	Show in Secondary Nav	Y	N	19
`cat_nav_footer_flag`	Show in Footer	Y	N	20
`cat_nav_flag`	Show in Nav Dropdown	Y	N	21
`show_items_in_nav`	Show Items In Nav	Y	N	22
`alt_cat_id1`	Alternate Parent Category	N	N	23
`alt_cat_id2`	Alternate Parent Category 2	N	N	24
`sort_by`	Sort By	Y	N	25
`filter`	Filter	N	N	25.6
`cat_show_only`	Visible for Which Users	Y	N	26
`breadcrumb_flag`	Show Breadcrumb	Y	N	27
`item_limit`	Item Limit	N	N	28
`hide_search`	Hide From Site Search	Y	N	29
`cat_searchwords`	Site Search Keywords	N	N	30
`template_name`	Component Name	Y	N	31
`component_layout`	Component Layout	Y	N	32
`list_action`	Page Action	Y	N	33
`component_wrapper`	Component Wrapper	Y	N	34
`component_identifier`	Component Identifier	Y	N	35
`cat_seo_title`	SEO Title	N	N	36
`cat_seo_blurb`	SEO Blurb	N	N	37
`cat_keywords`	SEO Keywords	N	N	38
`cat_form1`	Which Form	N	N	39
`email_submissions_to`	Email Submissions To	N	N	40
`submission_response`	Form Thank You Text	N	N	41
`cat_ext_link`	Section Button URL	N	N	42
`cat_ext_link_text`	Section Button Text	N	N	43
`cat_bg_color`	Section Background Color (optional)	N	N	44
`cat_color`	Section Text Color (optional)	N	N	45
`items_across_desk`	Items Across (Desktop)	N	N	46
`items_across_tab`	Items Across (Tablet)	N	N	47
`items_across_mob`	Items Across (Mobile)	N	N	48
`device`	Show on Devices	N	N	50.8
`bg_type`	Bg Type	N	N	50
`section_width`	Section Width	N	N	50.2
`cat_caption_style`	Caption Style	N	N	51
`cat_caption_position`	Caption Position	N	N	52
`cat_caption_effect`	Caption Effect	N	N	53
`cat_caption_classes`	Caption Classes	N	N	54
`developer_notes`	Developer Notes	Y	N	55
`locked`	Locked	Y	N	56
`item_count`	Item Count	N	N	57
`image_directory`	Image Directory	N	N	58
`alert_me_when_empty`	Alert Me When Empty	N	N	59
`addtocart_action`	Addtocart Action	N	N	60
`caption_style`	Caption Style	N	N	61
`card_effect`	Card Effect	N	N	62
`caption_position`	Caption Position	N	N	63
`animation`	Animation	N	N	64
`caption_effect`	Caption Effect	N	N	65

Products labels

Field	Label	Edit	List	Order
`hide_product`	Hide Product	Y	Y	1
`list_order`	Display Order	Y	Y	2
`product_name`	Name	Y	Y	3
`page_name`	Web Page Address	Y	N	4
`main_cat_id`	Main Category	Y	N	5
`product_image1`	Image	Y	N	5.1
`product_image2`	Product Image2	N	N	5.2
`product_image3`	Product Image3	N	N	5.3
`blurb1`	Description	Y	Y	5.4
`product_flag1`	Product Flag1	N	N	6
`product_flag2`	Product Flag2	N	N	7
`product_flag3`	Product Flag3	N	N	8
`custom1`	Custom1	N	N	9
`custom2`	Custom2	N	N	10
`custom3`	Custom3	N	N	11
`custom4`	Custom4	N	N	12
`glyphicon`	Glyphicon	N	N	12.2
`catalog_id`	Catalog ID	N	N	13
`price`	Price	N	N	15
`price2`	Price2	N	N	16
`sale_price`	Sale Price	N	N	17
`minimum_price`	Minimum Price	N	N	18
`wholesale_price`	Wholesale Price	N	N	19
`item_cost`	Item Cost	N	N	20
`allow_price_override`	Allow Price Override	N	N	21
`tax_exempt`	Tax Exempt	N	N	22
`sale_category`	Sale Category	N	N	23
`apply_sale_to_variants`	Apply Sale To Variants	N	N	24
`qty_on_hand`	Qty On Hand	N	N	25
`multiples`	Only Allow Orders in Multiples of:	N	N	26.5
`minimum_qty`	Minimum Qty	N	N	26
`limit_per_customer`	Limit Per Customer	N	N	27
`reorder_level`	Reorder Level	N	N	28
`enable_repeat_order`	Enable Repeat Order	N	N	29
`mm_item_type`	Mm Item Type	N	N	30
`brand`	Brand	N	N	31
`product_rating`	Product Rating	N	N	32
`vendor_id`	Vendor ID	N	N	33
`avg_product_rating`	Avg Product Rating	N	N	34
`item_account_id`	Item Account Id	N	N	35
`upc_code`	UPC Code	N	N	36.5
`bin_number`	Bin Number	N	N	36
`mpn`	MPN	N	N	37
`use_price_options`	Use Price Options	N	N	38
`retail_multiadd`	Retail Multiadd	N	N	39
`wholesale_multiadd`	Wholesale Multiadd	N	N	40
`shipping_charge`	Shipping Charge	N	N	41
`shipping_charge_type`	Shipping Charge Type	N	N	42
`require_shipping_quote`	Require Shipping Quote	N	N	43
`weight`	Weight	N	N	44
`package_specs`	Package Specs	N	N	45
`related_items`	Related Items	N	N	46
`blurb2`	Description 2	N	N	48
`short_description`	Short Description	N	N	49
`number1`	Number1	N	N	53
`number2`	Number2	N	N	54
`date1`	Date1	N	N	55
`date2`	Date2	N	N	56
`link1`	Link1	N	N	57
`link2`	Link2	N	N	58
`email_address`	Email Address	N	N	59
`show_only`	Show for Which Users	Y	N	60
`start_time`	Start Time	N	N	61
`end_time`	End Time	N	N	62
`date_created`	Date Created	N	N	63
`date_modified`	Date Modified	N	N	64
`seo_title`	SEO Title	N	N	65
`seo_blurb`	SEO Blurb	N	N	66
`keywords`	SEO Keywords	N	N	67
`include_as_option`	Include As Option	N	N	72
`locked`	Locked	Y	N	73
`options1`	Options1	N	N	74
`options2`	Options2	N	N	75
`options3`	Options3	N	N	76
`group_id`	Group Id	N	N	77
`overlay_text`	Overlay Text	N	N	78
`overlay_graphic`	Overlay Graphic	N	N	79
`nav_flag`	Nav Flag	N	N	80
`item_time2`	Item Time2	N	N	80
`nav_footer_flag`	Nav Footer Flag	N	N	81
`item_time1`	Item Time1	N	N	81
`alert_me_when_hidden`	Alert Me When Hidden	N	N	82
`textarea`	Textarea	N	N	83

Accounts labels

Field	Label	Edit	List	Order
`account_long`	Long	N	N	1
`account_tax_exempt`	Tax Exempt	N	N	1
`account_active`	Active	Y	Y	1
`account_lat`	Lat	N	N	1
`account_sales_rep`	Sales Rep	Y	Y	2
`account_email_address`	Email Address	Y	Y	2
`account_tax_id`	Tax Id	N	N	2
`account_date_joined`	Date Joined	Y	Y	3
`account_is_sales_rep`	Is Sales Rep	N	N	3
`account_otherinfo`	Otherinfo	N	N	3
`account_date_expires`	Date Expires	N	N	4
`account_date_last_ordered`	Date Last Ordered	N	N	4
`account_company_name`	Company Name	Y	Y	5
`account_total_orders`	Total Orders	N	N	5
`account_total_revenue`	Total Revenue	N	N	6
`account_last_name`	Last Name	Y	Y	6
`account_first_name`	First Name	Y	Y	7
`account_name`	Name	Y	Y	8
`account_password`	Password	N	N	9
`account_group`	Group	Y	Y	10
`account_referred_by`	Referred By	Y	Y	11
`account_telephone`	Telephone	Y	Y	12
`account_address1`	Address1	Y	Y	13
`account_address2`	Address2	Y	Y	14
`account_city`	City	Y	Y	15
`account_state`	State	Y	Y	16
`account_zip`	Zip	Y	Y	17
`account_country`	Country	Y	Y	18
`account_stelephone`	Stelephone	Y	Y	19
`account_saddress1`	Saddress1	Y	Y	20
`account_saddress2`	Saddress2	Y	Y	21
`account_scity`	Scity	Y	Y	22
`account_sstate`	Sstate	Y	Y	23
`account_szip`	Szip	Y	Y	24
`account_scountry`	Scountry	Y	Y	25
`account_session`	Session	N	N	26
`account_locked`	Locked	Y	Y	27

Qty prices labels

Field	Label	Edit	List	Order
`qty_display_order`	Display Order	Y	Y	1
`qty_show_details`	Show Details	Y	Y	2
`qty_show_only`	Show Only	Y	Y	3
`qty_sku_no`	Sku No	N	N	4
`qty_group_text`	Group Text	Y	Y	5
`qty_option_text`	Option Text	Y	Y	6
`qty_from_qty`	From Qty	Y	Y	7
`qty_to_qty`	To Qty	N	N	8
`qty_price`	Price	Y	Y	9
`qty_price2`	Price2	N	N	10
`qty_item_cost`	Item Cost	N	N	11
`qty_wholesale_price`	Wholesale Price	N	N	12
`qty_price_option`	Price Option	Y	Y	13
`qty_note`	Note	Y	Y	14
`qty_weight`	Weight	N	N	15
`qty_inventory`	Inventory	N	Y	16
`qty_reorder_level`	Reorder Level	N	N	17
`qty_shipping`	Shipping	N	N	18
`qty_image`	Image	Y	Y	19
`qty_parent_id`	Parent Id	Y	Y	20
`qty_minimum_price`	Minimum Price	N	N	21

Products edit-in-list

—

Categories edit-in-list

—

Qty prices edit-in-list

—

Payment

Payment processor

manual

Retail methods

PayPal===

Retail payment text

PayPal=|Check=|Money_Order=|Purchase_Order=|payment_method1:=|payment_method2:=|payment_method3:=

Wholesale methods

—

Wholesale payment text

—

Retail cards accepted

—

Wholesale cards accepted

—

Merchant ID

—

Merchant key

—

PayPal ID

riverk@terrafirmabotanicals.com

Gateway settings

a:5:{s:7:\"gateway\";s:12:\"authorizenet\";s:9:\"set_login\";s:8:\"asdfasdf\";s:19:\"set_transaction_key\";s:8:\"asdfasdf\";s:20:\"set_transaction_type\";s:4:\"sale\";s:30:\"set_wholesale_transaction_type\";s:5:\"salew\";}

Gateway 2 settings

a:2:{s:7:\"gateway\";s:6:\"manual\";s:20:\"set_secure_orders_to\";s:31:\"riverk@terrafirmabotanicals.com\";}

PayPal Express settings

—

Google Checkout settings

—

Shipping

Shipping quote text: —
Continental ship message: —
International ship message: —
Shipping notes: —
UPS info: —
USPS info: —

Feeds & analytics

Google feed user: —
Google feed password: —
Google feed topic: —
Google feed filename: —
Google category: —
UA tracking code: —
GA4 measurement ID: G-8QZB7YNNE0

Documents

PDF note: —
PDF label: —
PO note: —

Internal

date_time1: 0
date_time2: 0
date_time3: 0

Coming in iteration 2: order count, total sales, average order value, and recent-order activity for tfb2.