Delivery Slots
Database Structure
Coming soon: Iconic Delivery Slots is becoming part of Kadence Shop Kit. You may see both names used while we update the product, documentation, and customer experience.
Iconic Delivery Slots stores the information of delivery date and timeslot in the following locations:
- Custom table
wp_jckwds: This is a custom table created by Delivery Slots and contains the following columns.
| Column | Type |
|---|---|
| id | mediumint(9) |
| datetimeid | text NULL |
| processed | tinyint(1) NULL |
| order_id | mediumint(9) NULL |
| user_id | text NULL |
| expires | text NULL |
| date | datetime NULL |
| starttime | mediumint(4) unsigned zerofill NULL |
| endtime | mediumint(4) unsigned zerofill NULL |
| asap | tinyint(1) NULL |
2. Order meta: Delivery Slots also uses the order meta to store the delivery slots information within the orders when they are created. The following meta keys are used to store the information:
- jckwds_date
- jckwds_date_ymd
- jckwds_shipping_method
- jckwds_timeslot
- jckwds_timeslot_id
- jckwds_timestamp
3. Subscription orders use a different set of meta keys to store delivery slot information. The following meta keys are used for subscription orders:
- _iconic_wds_subscription_date_ymd
- _iconic_wds_subscription_date
- _iconic_wds_subscription_timeslot
- _iconic_wds_subscription_timeslot_id
- _iconic_wds_subscription_shipping_method
- _iconic_wds_subscription_timestamp
- _iconic_wds_subscription_anchor_day
Filed under
Uncategorized
Was this page helpful?
Thanks for the feedback!