Resolvedimport menu items

Viewing 4 posts - 1 through 4 (of 4 total)
  • Author
    Posts
  • #31036
    bkirby
    Participant

    How do I attach file? Here is a sample of the file.

    Item,Description,Price,Category

    Miso Soup,Add Real Carb $3.00,$1.95,Soup
    Butternut Squash Soup,Thick and delicious,$3.95,Soup

    Wakame,Seasonal Seaweed Salad,$4.95,Greens
    Edamame,Delicous,$4.95,Greens
    House Green Salad,Very healthy,$5.95,Greens
    Seafood Salad,Fresh from the sea,$7.95,Greens

    #31042
    Althemist
    Keymaster

    I am afraid you can’t attach files to messages. You can only post links to them – e.g. upload the file on your server and post link to it here.

    #31099
    bkirby
    Participant

    Hello
    As requested, here is the link to CSV file.

    Thank you!

    https://visioncast.ca/Qualicum_sushi_csv.csv

    #31100
    Althemist
    Keymaster

    That’s definitely not the correct format.

    For menu items (our own custom post type) it must be XML with the following structure for each item:

    <item>
    		<title><![CDATA[Western Bacon Angus Burger]]></title>
    		<link>https://lafka.althemist.com/fastfood/restaurant-menu/western-bacon-angus-burger/</link>
    		<pubDate>Fri, 05 Apr 2019 10:22:51 +0000</pubDate>
    		<dc:creator><![CDATA[Althemist]]></dc:creator>
    		<guid isPermaLink="false">https://lafka.althemist.com/fastfood/?post_type=lafka-foodmenu&p=2190</guid>
    		<description/>
    		<content:encoded><![CDATA[]]></content:encoded>
    		<excerpt:encoded><![CDATA[]]></excerpt:encoded>
    		<wp:post_id>2190</wp:post_id>
    		<wp:post_date><![CDATA[2019-04-05 10:22:51]]></wp:post_date>
    		<wp:post_date_gmt><![CDATA[2019-04-05 10:22:51]]></wp:post_date_gmt>
    		<wp:post_modified><![CDATA[2021-06-14 06:56:43]]></wp:post_modified>
    		<wp:post_modified_gmt><![CDATA[2021-06-14 06:56:43]]></wp:post_modified_gmt>
    		<wp:comment_status><![CDATA[closed]]></wp:comment_status>
    		<wp:ping_status><![CDATA[closed]]></wp:ping_status>
    		<wp:post_name><![CDATA[western-bacon-angus-burger]]></wp:post_name>
    		<wp:status><![CDATA[publish]]></wp:status>
    		<wp:post_parent>0</wp:post_parent>
    		<wp:menu_order>0</wp:menu_order>
    		<wp:post_type><![CDATA[lafka-foodmenu]]></wp:post_type>
    		<wp:post_password><![CDATA[]]></wp:post_password>
    		<wp:is_sticky>0</wp:is_sticky>
    										<category domain="lafka_foodmenu_category" nicename="burgers"><![CDATA[Burgers]]></category>
    						<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_rev_slider_before_header]]></wp:meta_key>
    		<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_prtfl_custom_content]]></wp:meta_key>
    		<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[_edit_last]]></wp:meta_key>
    		<wp:meta_value><![CDATA[1]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[slide_template]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_layout]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_top_header]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_footer_style]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_footer_size]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_header_size]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_page_subtitle]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_header_syle]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_title_background_imgid]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_title_alignment]]></wp:meta_key>
    		<wp:meta_value><![CDATA[centered_title]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_top_menu]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_show_title_page]]></wp:meta_key>
    		<wp:meta_value><![CDATA[yes]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_show_breadcrumb]]></wp:meta_key>
    		<wp:meta_value><![CDATA[yes]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_show_sidebar]]></wp:meta_key>
    		<wp:meta_value><![CDATA[no]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_sidebar_position]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_show_footer_sidebar]]></wp:meta_key>
    		<wp:meta_value><![CDATA[yes]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_show_offcanvas_sidebar]]></wp:meta_key>
    		<wp:meta_value><![CDATA[yes]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_show_share]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_custom_sidebar]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_custom_footer_sidebar]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_custom_offcanvas_sidebar]]></wp:meta_key>
    		<wp:meta_value><![CDATA[default]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_rev_slider]]></wp:meta_key>
    		<wp:meta_value><![CDATA[none]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_video_bckgr_url]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_video_bckgr_start]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_video_bckgr_end]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_video_bckgr_loop]]></wp:meta_key>
    		<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_video_bckgr_mute]]></wp:meta_key>
    		<wp:meta_value><![CDATA[0]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_item_single_price]]></wp:meta_key>
    		<wp:meta_value><![CDATA[10.99]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_item_size1]]></wp:meta_key>
    		<wp:meta_value><![CDATA[Extra Patty]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_item_price1]]></wp:meta_key>
    		<wp:meta_value><![CDATA[+3]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_item_size2]]></wp:meta_key>
    		<wp:meta_value><![CDATA[Extra Cheese]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_item_price2]]></wp:meta_key>
    		<wp:meta_value><![CDATA[+1]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_item_size3]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_item_price3]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_ingredients]]></wp:meta_key>
    		<wp:meta_value><![CDATA[Stacked high with avocado, pepper Jack, red onion, roasted jalape&#241;os, tomato & pickles]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_allergens]]></wp:meta_key>
    		<wp:meta_value><![CDATA[Soy, Milk, Gluten]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_ext_link_button_title]]></wp:meta_key>
    		<wp:meta_value><![CDATA[Custom Button]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_ext_link_url]]></wp:meta_key>
    		<wp:meta_value><![CDATA[#]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_add_description]]></wp:meta_key>
    		<wp:meta_value><![CDATA[Crispy on the outside, juicy on the inside and seasoned with salt, a classic munch with one slight difference, they are 100% Organic. Try with one of our internationally inspired sauces.]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_featured_imgid_2]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_featured_imgid_3]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_featured_imgid_4]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_featured_imgid_5]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_featured_imgid_6]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_prtfl_gallery]]></wp:meta_key>
    		<wp:meta_value><![CDATA[list]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[_wpb_vc_js_status]]></wp:meta_key>
    		<wp:meta_value><![CDATA[false]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[_thumbnail_id]]></wp:meta_key>
    		<wp:meta_value><![CDATA[3675]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[_wp_old_slug]]></wp:meta_key>
    		<wp:meta_value><![CDATA[burger-5]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_item_weight]]></wp:meta_key>
    		<wp:meta_value><![CDATA[310]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_item_weight_unit]]></wp:meta_key>
    		<wp:meta_value><![CDATA[g]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_nutrition_energy]]></wp:meta_key>
    		<wp:meta_value><![CDATA[290]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_nutrition_protein]]></wp:meta_key>
    		<wp:meta_value><![CDATA[28]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_nutrition_fat]]></wp:meta_key>
    		<wp:meta_value><![CDATA[12]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_nutrition_satfat]]></wp:meta_key>
    		<wp:meta_value><![CDATA[2.0]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_nutrition_carbs]]></wp:meta_key>
    		<wp:meta_value><![CDATA[26]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_nutrition_sugars]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							<wp:postmeta>
    		<wp:meta_key><![CDATA[lafka_nutrition_sodium]]></wp:meta_key>
    		<wp:meta_value><![CDATA[]]></wp:meta_value>
    		</wp:postmeta>
    							</item>

    For WooCommerce products it must have the original WooCommerce data structure:

    ID,Type,SKU,Name,Published,"Is featured?","Visibility in catalog","Short description",Description,"Date sale price starts","Date sale price ends","Tax status","Tax class","In stock?",Stock,"Backorders allowed?","Sold individually?","Weight (lbs)","Length (in)","Width (in)","Height (in)","Allow customer reviews?","Purchase note","Sale price","Regular price",Categories,Tags,"Shipping class",Images,"Download limit","Download expiry days",Parent,"Grouped products",Upsells,Cross-sells,"External URL","Button text",Position,"Attribute 1 name","Attribute 1 value(s)","Attribute 1 visible","Attribute 1 global","Attribute 2 name","Attribute 2 value(s)","Attribute 2 visible","Attribute 2 global","Meta: _wpcom_is_markdown","Download 1 name","Download 1 URL","Download 2 name","Download 2 URL"
    44,variable,woo-vneck-tee,"V-Neck T-Shirt",1,1,visible,"This is a variable product.","Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Vestibulum tortor quam, feugiat vitae, ultricies eget, tempor sit amet, ante. Donec eu libero sit amet quam egestas semper. Aenean ultricies mi vitae est. Mauris placerat eleifend leo.",,,taxable,,1,,0,0,.5,24,1,2,1,,,,"Clothing > Tshirts",,,"https://woocommercecore.mystagingwebsite.com/wp-content/uploads/2017/12/vneck-tee-2.jpg, https://woocommercecore.mystagingwebsite.com/wp-content/uploads/2017/12/vnech-tee-green-1.jpg, https://woocommercecore.mystagingwebsite.com/wp-content/uploads/2017/12/vnech-tee-blue-1.jpg",,,,,,,,,0,Color,"Blue, Green, Red",1,1,Size,"Large, Medium, Small",1,1,1,,,,

    You can check the XMLs and their structure in lafka/store/demo folder

    OR you can check the default WooCommerce CSV structure in the default WooComemrce sample_products file

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in and have valid license to reply to this topic.

License required for the following item
Login and Registration Log in · Register