Deprecated: Creation of dynamic property wpdb::$categories is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php on line 668

Deprecated: Creation of dynamic property wpdb::$post2cat is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php on line 668

Deprecated: Creation of dynamic property wpdb::$link2cat is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php on line 668

Deprecated: Return type of WP_Theme::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-theme.php on line 554

Deprecated: Return type of WP_Theme::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-theme.php on line 595

Deprecated: Return type of WP_Theme::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-theme.php on line 535

Deprecated: Return type of WP_Theme::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-theme.php on line 544

Deprecated: Return type of WP_REST_Request::offsetExists($offset) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-request.php on line 952

Deprecated: Return type of WP_REST_Request::offsetGet($offset) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-request.php on line 972

Deprecated: Return type of WP_REST_Request::offsetSet($offset, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-request.php on line 984

Deprecated: Return type of WP_REST_Request::offsetUnset($offset) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-request.php on line 995

Deprecated: Return type of WP_Block_List::current() should either be compatible with Iterator::current(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 151

Deprecated: Return type of WP_Block_List::next() should either be compatible with Iterator::next(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 175

Deprecated: Return type of WP_Block_List::key() should either be compatible with Iterator::key(): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 164

Deprecated: Return type of WP_Block_List::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 186

Deprecated: Return type of WP_Block_List::rewind() should either be compatible with Iterator::rewind(): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 138

Deprecated: Return type of WP_Block_List::offsetExists($index) should either be compatible with ArrayAccess::offsetExists(mixed $offset): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 75

Deprecated: Return type of WP_Block_List::offsetGet($index) should either be compatible with ArrayAccess::offsetGet(mixed $offset): mixed, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 89

Deprecated: Return type of WP_Block_List::offsetSet($index, $value) should either be compatible with ArrayAccess::offsetSet(mixed $offset, mixed $value): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 110

Deprecated: Return type of WP_Block_List::offsetUnset($index) should either be compatible with ArrayAccess::offsetUnset(mixed $offset): void, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 127

Deprecated: Return type of WP_Block_List::count() should either be compatible with Countable::count(): int, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp-block-list.php on line 199

Deprecated: Creation of dynamic property POMO_FileReader::$is_overloaded is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/streams.php on line 21

Deprecated: Creation of dynamic property POMO_FileReader::$_pos is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/streams.php on line 22

Deprecated: Creation of dynamic property POMO_FileReader::$_f is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/streams.php on line 153

Deprecated: Creation of dynamic property MO::$_gettext_select_plural_form is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/translations.php on line 293

Deprecated: Creation of dynamic property POMO_FileReader::$is_overloaded is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/streams.php on line 21

Deprecated: Creation of dynamic property POMO_FileReader::$_pos is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/streams.php on line 22

Deprecated: Creation of dynamic property POMO_FileReader::$_f is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/streams.php on line 153

Deprecated: Creation of dynamic property MO::$_gettext_select_plural_form is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/translations.php on line 293

Deprecated: Creation of dynamic property POMO_FileReader::$is_overloaded is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/streams.php on line 21

Deprecated: Creation of dynamic property POMO_FileReader::$_pos is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/streams.php on line 22

Deprecated: Creation of dynamic property POMO_FileReader::$_f is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/streams.php on line 153

Deprecated: Creation of dynamic property MO::$_gettext_select_plural_form is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/pomo/translations.php on line 293

Deprecated: trim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/class-wp.php on line 173

Warning: Cannot modify header information - headers already sent by (output started at /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php:668) in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-server.php on line 1637

Warning: Cannot modify header information - headers already sent by (output started at /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php:668) in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-server.php on line 1637

Warning: Cannot modify header information - headers already sent by (output started at /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php:668) in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-server.php on line 1637

Warning: Cannot modify header information - headers already sent by (output started at /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php:668) in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-server.php on line 1637

Warning: Cannot modify header information - headers already sent by (output started at /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php:668) in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-server.php on line 1637

Warning: Cannot modify header information - headers already sent by (output started at /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php:668) in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-server.php on line 1637

Deprecated: ltrim(): Passing null to parameter #1 ($string) of type string is deprecated in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php on line 3031

Warning: Cannot modify header information - headers already sent by (output started at /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php:668) in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-server.php on line 1637

Warning: Cannot modify header information - headers already sent by (output started at /home/cloudy17/instructions.whiskyzulu.net/wp-includes/wp-db.php:668) in /home/cloudy17/instructions.whiskyzulu.net/wp-includes/rest-api/class-wp-rest-server.php on line 1637
{"id":148,"date":"2019-11-01T13:20:41","date_gmt":"2019-11-01T13:20:41","guid":{"rendered":"http:\/\/instructions.whiskyzulu.net\/?p=148"},"modified":"2020-08-17T09:11:53","modified_gmt":"2020-08-17T09:11:53","slug":"004-cask-inventory-database-crm","status":"publish","type":"post","link":"https:\/\/instructions.whiskyzulu.net\/index.php\/2019\/11\/01\/004-cask-inventory-database-crm\/","title":{"rendered":"0040 CASK Inventory Database – Getting started with the customer relations management (CRM) aspects"},"content":{"rendered":"\n

For distilleries that sell casks to private individuals it is important to match up individual contact details with individual casks and allow notes to be held against those casks. The CASK Inventory Database has tables that will allow you to store individuals details and organisation details and link these to casks in a many to many relationship. What this means is that you can store not just the primary individual linked to a cask but any number of other individuals. This allows cask owners to grant (with prior agreement from the distillery) some of the benefits of ownership to partners \/ relatives and friends as distilleries allow this assists the distillery in creating a family experience to the ownership of a cask while letting the distillery be aware of the important individuals related to a cask. Private ownership of casks requires these detailed notes as casks will typically be stored for many years and the circumstances of the original owner may change , even without circumstance change it is likely there will be months between contacts of individual owners getting in touch. Multiply this by hundreds of separate individuals and hundreds of casks and it is therefore very important to be able to trace individuals to casks based on a variety of identifiers. Name \/ email \/ home address are all useful in linking back should an individual get in touch – The CASK Inventory Database has been designed specifically to assist in this.<\/p>\n\n\n\n

\"\"
Navigating to persons organisations and notes<\/figcaption><\/figure><\/div>\n\n\n\n

The principle behind this method of holding individual details is that the names and organisations are input first and then these are added to the cask. This is because this method references the index of the individual or person to the cask and not the text. This was designed this way as it has some the advantages that details can be cascaded to all casks when person or organisation details are updated or if an individual owns multiple casks.<\/p>\n\n\n\n

The following shows the persons table shown (here for privacy I have put in my own details) normally there may be many hundreds or thousands of individuals in here.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

For all individuals you wish to relate to casks enter details here. PLEASE note the Organisation field of the persons table references the organisation table and you will need to enter all required organisations before they can be selected and added to the individuals record.<\/p>\n","protected":false},"excerpt":{"rendered":"

For distilleries that sell casks to private individuals it is important to match up individual contact details with individual casks and allow notes to be held against those casks. The CASK Inventory Database has tables that will allow you to store individuals details and organisation details and link these to casks in a many to… Continue reading 0040 CASK Inventory Database – Getting started with the customer relations management (CRM) aspects<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/posts\/148"}],"collection":[{"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/comments?post=148"}],"version-history":[{"count":16,"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/posts\/148\/revisions"}],"predecessor-version":[{"id":419,"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/posts\/148\/revisions\/419"}],"wp:attachment":[{"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/media?parent=148"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/categories?post=148"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/instructions.whiskyzulu.net\/index.php\/wp-json\/wp\/v2\/tags?post=148"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}