Import/Export Archives - Business Bloomer

WooCommerce: Safely Sync Live Orders And Subs To A Dev Site

code, coding, computer, data, developing, development, ethernet, html, programmer, programming, screen, software, technology, work, code, code, coding, coding, coding, coding, coding, computer, computer, computer, computer, data, programming, programming, programming, software, software, technology, technology, technology, technology

In a recent Business Bloomer Club Slack thread, the discussion focused on a common challenge during WooCommerce rebuilds: how to sync a live store with a development version, especially when it comes to orders, customers, and subscriptions.

There are two main scenarios here. One involves rebuilding a WooCommerce store and needing to migrate recent transactional data (e.g. orders placed after a staging site was cloned). The other is syncing a fresh WooCommerce site with a copy of an existing store — without duplicating live payment authorizations or triggering emails.

This can be tricky and risky. Subscriptions in particular are sensitive, as duplicating them could result in revoked payment tokens or even failed renewals. Fortunately, both tools and real-life experiences were shared in the thread, providing a useful reference for developers quoting similar Woo projects.

Should Clients Add WooCommerce Products Themselves?

Two professionals discussing a contract with documents on a table, indoors.

In a recent Business Bloomer Club Slack thread, we discussed the best approach when onboarding a client to a newly built WooCommerce store—especially when it comes to adding their products for the first time.

Should you walk them through the WordPress admin UI and teach them how to do it manually? Or do you require them to compile their inventory in a spreadsheet that can then be imported?

The trigger for this discussion was a tweet wondering what other developers typically do: teach or template? The real answer, unsurprisingly, is “it depends.”

Syncing WooCommerce Data After a Redesign

Close-up of a network server rack with blinking LEDs, showcasing Ethernet connections and patch panels.

Redesigning a WooCommerce website is a significant undertaking, often involving a complete rebuild with a fresh design, enhanced functionality, and potentially a new page builder.

A crucial step in this process is synchronizing the data from the existing, live site with the newly developed site. This ensures that the redesigned site launches with the most up-to-date information, including recent orders, customer details, product updates, and other essential data.

However, this data synchronization can be a complex process, especially when the redesign involves substantial changes to the site’s structure, database schema, or content. Choosing the right approach is vital to minimize downtime, prevent data loss, and ensure a smooth transition to the new site.

This post explores several strategies for syncing WooCommerce data after a redesign, discussing the pros and cons of each method and offering practical advice for navigating this critical phase of the development process. From using import/export plugins to leveraging command-line tools and considering staging environments, we’ll cover the various options available and provide guidance on selecting the best approach for your specific needs.

WooCommerce: How to Configure Product and Order Sync

Overhead view of black modern electronics including smartphone, headphones, speaker, and controller on a table.

This is a guest post by Misha Rudrastyh of rudrastyh.com. If you like the content, make sure to thank him in the comments!

In this article, I’d like to talk about syncing products and orders between different standalone WooCommerce stores. More specifically, I am going to uncover the following topics:

What WordPress/WooCommerce hooks do we need to use to trigger the sync?
How to create the WooCommerce REST API requests inside the callback functions for the above-mentioned hooks.
How to do it without coding at all, just using a plugin.

Of course, for products, we are going to sync all the product information, like gallery images, attributes, variations, etc. For orders: billing, shipping addresses, custom metadata, customers, etc. But we will come back to this moment a little bit later as well.

WooCommerce: Custom Product Sales CSV Report

office work, work, office, folder, files, file folder, balance sheet, accounting, invoice, management, organization, folder, files, files, files, files, files, accounting, accounting, accounting, invoice

In a recent Business Bloomer Club Slack thread, a community member shared a custom solution to generate a product sales report in WooCommerce. This solution allows administrators to export the total quantity of each product sold over a specified period.

The export is in CSV format, which is easily accessible for analysis or record-keeping. This functionality is particularly valuable for store owners who need detailed insights into their product sales performance. By leveraging this custom solution, you can streamline your reporting process and stay on top of product performance.

This post includes a legacy version and also an updated snippet for WooCommerce with High-Performance Order Storage (HPOS) compatibility, which improves the handling of orders and metadata. Keep reading to explore the full solution and how it works in both the standard and HPOS versions.

Finding a Complete WooCommerce Sample Data Set: 1000s of Products, Customers, and Orders

In a recent Business Bloomer Club discussion, WooCommerce developers and store owners discussed the challenges of sourcing a complete set of sample data for testing purposes.

While WooCommerce provides some basic sample data, it often includes only products, leaving out comprehensive information on customers and orders. For developers looking to conduct realistic performance and functionality tests on larger datasets, this is limiting.

Comprehensive sample data can be valuable for testing workflows, simulating customer interactions, and evaluating site performance under load. In this post, we’ll review existing resources, limitations, and ideas on building or sourcing a complete data set for your WooCommerce needs.

Planning a WooCommerce Setup for a High-Traffic Site with API Integration

In a recent Business Bloomer Club discussion, a developer was worried that a high-traffic WordPress website had raised concerns about implementing WooCommerce to handle complex requirements.

The site expects 100,000 visitors during peak times and will sell tickets, merchandise, and manage user registration through a custom single sign-on (SSO) system.

Additionally, product data will be pulled from an external API rather than WooCommerce’s internal database. Key considerations include balancing the flexibility of WooCommerce with high server demand, handling frequent data updates through an API, and ensuring smooth transactions during peak ticket sales.

WooCommerce: Synchronizing Product Stock Between Stores

Wide angle view of a warehouse with stocked shelves and boxes.

This is a guest post by Misha Rudrastyh of rudrastyh.com. If you like the content, make sure to thank him in the comments!

In this post, we will discuss different ways of syncing product stock levels between multiple WooCommerce stores, more specifically, we will take a look at the following topics:

What is a multisite installation of WooCommerce stores, and what is the difference between syncing products across stores within a single multisite network and standalone stores?
Is there any difference between when we do the sync after updating a product via the WooCommerce admin dashboard and when an order is created by a customer?
Some caveats when working with orders which can contain lots of products.
What do we need to do to run the bulk stock synchronization for all products on a WooCommerce store?

If you’re interested in syncing more product data, not just the stock information, you can take a look at this article.

This tutorial is mostly about using Inventory Sync for WooCommerce plugin, however, if you’re a developer, you will also find some hook and performance recommendations here.

Changing Product IDs in WooCommerce: Feeds and Migration Considerations

In a recent Business Bloomer Club discussion, a member faced a challenge with product IDs after migrating a WooCommerce store. During the import/export process, product IDs changed, impacting shopping feeds that relied on the original IDs for platforms like Google Shopping and Amazon.

While fixing the issue by changing product IDs in the live database might seem straightforward, it’s a complex and high-risk process, as WooCommerce and various plugins reference product IDs extensively across the database.

Here’s a breakdown of why this issue occurred, the possible solutions, and best practices for future migrations.

Synchronizing WooCommerce Product Data Across Multiple Sites

In a recent Business Bloomer Club discussion, a member shared their plan to create a network of WooCommerce stores by cloning a master site into two separate domains with unique branding.

The goal was to sync product details—additions, deletions, and modifications—from the master site to the “slave” sites in real time, while omitting orders and user data.

Additionally, the slave sites won’t have a shopping cart or checkout; users will simply be redirected to the master site to complete purchases.

This setup required a straightforward, cost-effective solution, and while many plugins offer extensive syncing capabilities, the user sought a minimalistic approach for basic product data synchronization. Below, we explore potential solutions to achieve this streamlined WooCommerce sync across multiple sites.

How to Migrate Product Reviews, Orders, and Customers During a WooCommerce Redesign

In a recent Business Bloomer Club Slack thread, a WooCommerce designer shared their challenge of redesigning a client’s slow, outdated website.

The plan involved rebuilding the site from scratch on a lightweight, block-based theme while transferring 10 core products, existing product reviews, past orders, and customer data to the new site.

When faced with such a significant migration, transferring these elements manually can be complex, but with the right tools, the process becomes much simpler.

Bulk Editing Product Attribute Variations in WooCommerce Without Crashing

In a recent Business Bloomer Club Slack thread, a WooCommerce user needed to bulk edit product attributes across a large catalog.

Specifically, they wanted to modify only certain attributes, leaving others untouched, without relying on WP All Import due to timeout issues when dealing with a high volume of products.

This guide covers how to approach this type of bulk attribute modification using both database and code-based solutions while minimizing the risk of timeouts or errors.

WooCommerce: How to Cross-Sell on Other Stores to Expand Your Reach

Growing an ecommerce store isn’t getting any easier. With acquisition costs skyrocketing—up 222% over the last eight years—relying solely on paid ads is becoming less sustainable. Plus, new competitors are entering the market in droves, making it even harder to attract and retain customers.

So how do you cut through the noise and stand out?

One clever strategy is cross-selling your products on other stores.

In simple terms, this means making your products available for sale on complementary ecommerce stores. By partnering with stores that align with your brand or leveraging your own network of stores, you can introduce your products to new customer bases, boosting your visibility and sales—all without spending a cent on ads. Meanwhile, your partner and expansion stores get to effortlessly expand their product offerings. Win-win.

Cross-selling is one of the few low-cost ways to drive fast, meaningful sales in this crowded market. It’s also a key reason why we developed the Syncio plugin—to help WooCommerce stores grow through seamless collaboration.

Of course, like any growth strategy, cross-selling comes with its own challenges. From managing products across stores to finding the right partners, it requires the right tools and approach to work. In this guide, we’ll walk you through how to efficiently cross-sell your WooCommerce products across stores.

WooCommerce: Allow CSV Product Export By Tag

Ok, this is a little hacky and pretty manual, but it happened to me in the past that the inbuilt WooCommerce CSV product export was just not enough.

In other words, the default product export that you can find by clicking the “Export” button on the “Products” WordPress Dashboard screen, gives you the option to export all products to a CSV. You can also refine the list by product type and product category, so that you can export specific products only.

What’s missing there is a “product tag” filter, so this workaround will let you do just that – define a product tag slug in the snippet below, and your export list will be automatically filtered by that.

Of course, you could find a dynamic way of doing that, but for now we’ll keep this manual and hardcoded into the PHP function. Enjoy!

WooCommerce: How To Migrate From Shopify

WooCommerce and Shopify are two of the greatest and most popular eCommerce platforms that allow you to create your online store and generate significant income.

However, as businesses grow – the need for a customizable, flexible, and feature-packed eCommerce platform that offers better control arises. And this is why some entrepreneurs migrate their online store from Shopify to WooCommerce.

Approximately 29% of all online stores use WooCommerce, signifying the sheer popularity of WooCommerce. However, there are still many merchants out there who are not using WooCommerce but have every reason to. The only problem is that switching eCommerce platforms and migrating your store’s products, orders, and customers requires the utmost care and precision to prevent data losses and ensure a smooth migrating process.

So, if you wish to switch your eCommerce platform and sell your products through WooCommerce – this article is for you. In this article, we share some plugins you can use to migrate your store from Shopify to WooCommerce with ease.

But first, let’s look at some reasons and benefits behind considering Shopify to WooCommerce migration.

Tag: Import/Export