Import/Export Archives - Business Bloomer

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.

WooCommerce: How To Set Up Dropshipping

Are you interested in dropshipping but don’t know what you need to get started? Join me as I explain how to start dropshipping in WordPress with the right tools and no monthly payments.

If you’ve considered using WooCommerce as your dropshipping platform there are many ways you can implement it – one on the solutions is the SaleSource plugin.

WooCommerce: How to Export/Import Products

Maybe you don’t know that, but WooCommerce has an inbuilt functionality for importing and exporting products from CSV/XML files. Therefore, most of the times, you don’t need a premium import/export plugin.

Simply go to WordPress Dashboard > Products > All Products and click on Import (or Export) and follow the instructions. That’s it!

This is a new functionality introduced since WooCommerce 3.0 and it’s working like a charm.

For more advanced import/export, automatic updates from server and more complex functionalities, take a look at WP All Import + WooCommerce Add-On

WooCommerce: Import California Tax Rates (.csv)

It took me ages to find a way to import ALL California tax rates into WooCommerce. I started by hand, and after a while I said to myself “California is crazy! I wouldn’t want to be an accountant there!”.

As usual, I looked for existing free and premium plugins, but I decided to do it my way. this tutorial gives you a ready-made CSV with all California US tax rates (as of 9 August 2014). Yes, it’s out of date, but you can download it, see how it is built, revise it with the correct rates, and follow the tutorial. Continue reading WooCommerce: Import California Tax Rates (.csv)

Tag: Import/Export