Importing product popularity data

  • Resolved rudolfl

    (@rudolfl)


    5 years, 4 months ago

    Hi all,

    I am working on transferring an e-commerce site from another engine to WordPress.

    I would like to preserve product popularity data. For each product I can extract counts on how many ties it was purchased and viewed. And I would like to import this data into WooCommerce so that products are correctly sorted by popularity.

    Example files do not contain this data.
    CSV column refernce (docs.woocommerce.com/document/product-csv-import-suite-column-header-reference/) is not loading for me.

    Can someone tell me what fields to populate?

    Thanks,
    Rudolf

Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Support Ryan Ray, a11n

    (@ryanr14)

    Hi @rudolfl,

    From my best knowledge a popular product in WooCommerce uses a count of how many times it’s been ordered. So for your import from one ecommerce platform to WooCommerce will you also be importing orders?

    If so, that should populate the right field for you. If it doesn’t look in the wp_postmeta table and finding a product by its ID you’ll then see a row for total_sales. That meta value can be modified to account for the number of sales in the previous system.


    Link to image: https://cld.wthms.co/7KZ3NR

    I hope that helps!

    Thread Starter rudolfl

    (@rudolfl)

    Thank you,

    That is exactly what I was looking for:
    meta:total_sales

    Rudolf

    Plugin Support Ryan Ray, a11n

    (@ryanr14)

    Hi @rudolfl,

    Woo, glad that was what you were looking for. Happy to help!

Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Importing product popularity data’ is closed to new replies.