- First prepare the data in the below format, note that the first one, Monday, is multi-slot and rest of them are single slot. So follow that for multi-slot.
{
"monday" : {
"enable" : "enable",
"start" : {
"0" : "0:45",
"1" : "1:45"
},
"close" : {
"0" : "06:45",
"1" : "7:45"
}
},
"tuesday" : {
"enable" : "enable",
"start" : "01:00",
"close" : "01:30"
},
"wednesday" : {
"enable": "enable",
"start" : "01:00",
"close" : "01:30"
},
"thursday" : {
"enable": "enable",
"start" : "01:00",
"close" : "01:30"
},
"friday" : {
"enable": "enable",
"start" : "01:00",
"close" : "01:30"
},
"saturday" : {
"enable": "enable",
"start" : "01:00",
"close" : "01:30"
},
"sunday" : {
"enable" : "enable",
"start" : "01:00",
"close" : "01:30"
}
}
- Then serialize this data, you can use this tool: https://duzun.me/playground/serialize
- After serilization is done, you'll have to replace the double quotes using sinlge quotes, you can use this tool: http://www.unit-conversion.info/texttools/replace-text/
- Insert the data you got from the previous step to your CSV.
- Then you'll have to insert this code into your themes functions.php, or if you're using any Code Snippet plugin, you can use that too:
add_action('init', function(){
$tools = ATBDP()->tools;
$tools->importable_fields['bdbh'] = "Business Hours";
});
- Finally just upload the CSV and map the fields accordingly and you should be good to go.
A couple of questions...