Data migration - by nebcreative - on WordPress WooCommerce support

This topic has 10 replies, 3 voices, and was last updated 4 years, 1 months ago ago by Olga Barlow

  • Avatar: nebcreative
    nebcreative
    Participant
    February 15, 2020 at 13:47

    I am working with a data migration company to utilize a wholesale parts suppliers api on a clients site. We are trying to figure out how to bring all the brands and connect them to the themes brand taxonomy, I will add him into an email response from you if that is possible and maybe he can give some insight on what we may need to do it or if you have any suggestions maybe he can elaborate on it. The site is using the x theme and url is kineticmotorworks.com my email address is neb@nebcreative.com again i want to try to include him in the email his email is jay@dataheretothere.com thank you

    9 Answers
    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    February 15, 2020 at 13:58

    Hello,

    Please read this topic – https://www.8theme.com/topic/how-can-i-export-a-product-list-to-csv-with-brands/
    If this is not what you are looking for, please describe your question in more detail.

    Regards

    Avatar: nebcreative
    nebcreative
    Participant
    February 16, 2020 at 04:19

    the data would be coming in from a data source via api and would connect to the store as it already does BUT the brands aspect is part of your theme based on what my api developer is stating. that he isnt seeing it outputted nor inputted in the same data as products and categories ect thus why i reached out to you to see where the Brands data in the x theme is connected in database so a possible solution can be made.

    thanks
    Nate

    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    February 17, 2020 at 16:37

    Hello,

    You can check this function ->
    global $post;
    wp_get_post_terms( $post->ID, ‘brand’ ) // returns array with all brands for product

    Regards

    Avatar: nebcreative
    nebcreative
    Participant
    February 20, 2020 at 02:12

    Thank you Rose. We actually need the opposite – a way to import the brands.

    We created a CSV file with the sku and brand name, then imported it using the WordPress CSV import tool. The file looks like this:

    sku,brand
    3000501,BrandX
    422421,BrandY
    600465,BrandZ

    However, this did not set the brands on the products. Is there a way we can import the brands on to existing products?

    Avatar: Rose Tyler
    Rose Tyler
    Support staff
    February 20, 2020 at 17:01

    Hello,

    Right now there is no ready solution for such import, it requests additional development/customization that can be done individually and it is paid service. If you agree, contact us by email – 8themes@gmail.com

    Also, you can try to use WP All Import/Export and WP All Import – WooCommerce Add-On plugins (Import Products from any XML or CSV to WooCommerce). We did not test these plugins with XStore officially so we can’t give a full guaranty, but some of our clients use them.

    Regards

    Avatar: nebcreative
    nebcreative
    Participant
    March 3, 2020 at 00:25

    Thank you Rose. We actually need the opposite – a way to import the brands.

    We created a CSV file with the sku and brand name, then imported it using the WordPress CSV import tool. The file looks like this:

    sku,brand
    3000501,BrandX
    422421,BrandY
    600465,BrandZ

    However, this did not set the brands on the products. Is there a way we can import the brands on to existing products?

    Avatar: Olga Barlow
    Olga Barlow
    Support staff
    March 3, 2020 at 12:44

    Hello,

    Could you try to use the WP All Import plugin to import your CSV file for products?

    Regards

    Avatar: nebcreative
    nebcreative
    Participant
    March 15, 2020 at 03:15

    so I have that installed I just dont know the correlation between woocomerce and your theme brand component of the xstore theme?

    Avatar: Olga Barlow
    Olga Barlow
    Support staff
    March 16, 2020 at 15:37

    Hello,

    1) Using WP All export make the export file of your products
    2) Using WP All import + WP All Import WooComerce addon http://prntscr.com/rh8972 import products:
    a) https://prnt.sc/rh7see
    b) during step 3 in addition to title, description, price etc add the brand https://gyazo.com/a28b19bb96efb99cd52b9d506b576cf2
    Follow the next steps according to pluugin documentation.

    Regards

  • Viewing 10 results - 1 through 10 (of 10 total)

You must be logged in to reply to this topic.Log in/Sign up

We're using our own and third-party cookies to improve your experience and our website. Keep on browsing to accept our cookie policy.