Connect with us

WORDPRESS

How to Import & Export WooCommerce Products with Images

Published

on

How to Import & Export WooCommerce Products with Images

Do you want to import and export WooCommerce products with images?

Importing or exporting WooCommerce products with images allows you to easily move your store or add new products in multiple stores.

In this article, we will show you how to easily import and export WooCommerce products with images.

Why Import & Export WooCommerce Products?

Many users need to import and export WooCommerce products for a number of reasons.

  • You may want to move products from one WooCommerce store to another
  • You may want to start an online store with a new WordPress website but with the same WooCommerce products
  • You may want to move your website to a new server but need a better way to move products
  • You may want a faster way to add your products to multiple stores that you manage
  • and more

Now normally if you are moving your website to a new server, then you can just duplicate your entire website and set it up on your new host.

We have a complete step-by-step guide for that, see how to easily move WordPress to a new host or server.

On the other hand, if you only want to move products, then this tutorial will help you learn how to properly export and import WooCommerce products with images and other product data.

We’ll show you two methods, you can choose one that works best for you.

Method 1. Import & Export WooCommerce Products without a Plugin

WooCommerce comes with built-in functionality to easily import and export products with images, but without using any additional plugins.

First, you need to visit the Products » All Products page in your WordPress admin area. There, you will see two buttons at the top to ‘Import’ or ‘Export’ products.

Import export WooCommerce products

Let’s first check out how the export feature works.

Exporting WooCommerce Products without Using a Plugin

Simply click on the ‘Export’ button at the top to continue.

On the next screen, you’ll see a bunch of options to choose what data you want to export.

Default WooCommerce product export options

For instance, you can choose to only export certain columns from product data. You can also choose to export specific product types or products in specific categories.

To export all products with images and all other data, you can leave these options unchecked.

Optionally, you can check the ‘Export custom meta.’ If you are unsure, then it’s better to check it so that you have the data.

Go ahead and click on the ‘Generate CSV’ button to continue.

WooCommerce will now prepare a CSV file and download it to your computer.

What is a CSV File?

CSV is short for Comma Separated Values, and it is file type of plain text that separates different columns or fields of data with a comma.

You can open it with any spreadsheet software like Google Sheets or Microsoft Excel. Here is how it would look:

CSV file opened in spreadsheet software

Importing WooCommerce Products without Using a Plugin

Simply go to the Products » All Products page and click on the Import button at the top.

Import products

If your WooCommerce store is empty, then instead of the buttons at the top, you will see buttons at the center of the page.

Click on the ‘Start Import’ button to begin the import.

Start import

This will bring up the import wizard.

First, you need to click on the ‘Choose File’ button to select the WooCommerce export CSV file you downloaded earlier.

Choose import file

Click on the continue button to upload the CSV file.

WooCommerce will now check to see if your CSV file is in a compatible format. After that, it will ask you to map that data to existing WooCommerce product data.

Map columns

The default settings here will work for most WooCommerce stores.

However, you still need to review and if a column is missing, and then click on the drop-down menu next to it and select a matching field if available.

Particularly, if you are using variations attribute for products, then make sure to scroll down to the attributes columns and match fields.

Match attribute fields

This will allow you to ensure that the fields in your CSV file match the corresponding WooCommerce fields.

Click on the ‘Run’ the Importer button to begin.

WooCommerce will now start importing data from CSV file. It will also download any images attached to your products.

Products imported

Once finished, you can visit the Products » All Products page to see the imported products.

Make sure to visit your shop and product pages to check that everything is working as expected.

Method 2. Import & Export WooCommerce Products with a Plugin

For this method, we’ll be using a plugin to import and export WooCommerce products.

The advantage of this method is that it offers more flexible options and also allows you to export / import product reviews.

Plus, it allows you to import / export WooCommerce products in batches which comes in handy if you have a large store with many products and images.

Exporting WooCommerce Products with a Plugin

First, you need to install and activate the Product Import Export for WooCommerce plugin. For more details, see our step-by-step guide on how to install a WordPress plugin.

The plugin comes as three separate addons. You’ll need to download and install all of them.

Download plugins

Upon activation, you need to visit the Webtoffee Import Export (Pro) » Export page and select the ‘Product’ as the post type you want to export.

Exporting WooCommerce products using a plugin

On the next screen, you need to select an export method.

The default Quick Export method automatically selects all your products for export.

Quick export method

Optionally, you can also choose ‘Advanced Export’ which allows you to filter products by category, tag, and status.

You can also exclude individual products manually.

Advanced filtering options

Click on the Export button to continue and the plugin will start preparing your product data.

Once finished, you’ll be prompted to download the export file to your computer.

Download export file

Importing WooCommerce Products with a Plugin

Now that you have your export file ready, you can use it to import products on another WooCommerce store.

Simply install and activate the Product Import Export for WooCommerce plugin on the store where you need to import the products.

After that, go to the Webtoffee Import Export (Pro) » Import page and select ‘Product’ as the post type you want to import.

Import products using a plugin

Click on the ‘Step 2: Select import method’ button to continue.

Next, you need to select an import method and upload the exported file you downloaded earlier to your computer.

Import method

Click on the ‘Step 3: Map and Import Columns’ button to continue.

On the next screen, you’ll see a list of fields and the matching fields from your import file. If you see an empty field, you can choose a matching field for it in the next column.

If you are using product variations like sizes and colors, then make sure to click on the Attributes tab to match attribute fields.

Map fields

However, if you are not using any products with variations or custom attributes then you can use the default settings.

Click on the ‘Step 4: Advanced Options / Batch Import’ button to continue.

On the final screen, you’ll see advanced options. For instance, you can choose to match products by ID or SKU, choose what to do if a product already exists, and more.

Import options

If you are importing products into an empty WooCommere store, then you can use the default settings.

Finally, click on the ‘Import’ button to run the product import process.

You’ll see the progress of the import on screen. Once finished, you can click on ‘View Products’ to check if everything has been imported correctly.

products imported

The plugin also allows you to import and export Product Reviews.

If you want to import or export the product reviews too, then simply choose ‘Product Reviews’ post type on the import or export page.

Import or export product reviews

Improve Your WooCommerce Store with Automations

If you find yourself doing a lot of manual work around your WooCommerce store and want to save time, then we recommend using Uncanny Automator for workflow automation.

Uncanny Automator helps you connect over 100+ plugins and apps with a simple no-code visual builder. You can use it to create automated workflows for things that you normally do without writing any code.

There’s a free version that you can try out, and it’s already used by over 20,000 websites.

Aside from workflow automation, if you’re looking for a marketing automation tool for WooCommerce, then we recommend using FunnelKit Automation. It will help you grow your sales and improve conversions without the high costs.

We hope this article helped you learn how to easily import and export WooCommerce products with images in WordPress. You may also want to see our pick of the essential WooCommerce plugins or see these practical tips on recovering abandoned cart sales in WooCommerce.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.



Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address

WORDPRESS

This sneaky credit card stealer hides within payment processors to avoid security scans

Published

on

Credit card

A sneaky new credit card stealer has been discovered hiding in places that are difficult to scan, and thus managing to steal payment (opens in new tab) information without triggering any alarms.

A report from cybersecurity experts Sucuri notes how it stumbled upon the malware when called in to investigate an “unusual infection” at one of its clients’ payment endpoints.

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

WORDPRESS

Hackers inject credit card stealers into payment processing modules

Published

on

Card

A new credit card stealing hacking campaign is doing things differently than we have seen in the past by hiding their malicious code inside the ‘Authorize.net’ payment gateway module for WooCommcerce, allowing the breach to evade detection by security scans.

Historically, when threat actors breach a commerce site like Magenta or WordPress running WooCommerce, they inject malicious JavaScript into the HTML of the store or customer checkout pages. 

These scripts will then steal inputted customer information on checkout, such as credit card numbers, expiration dates, CVV numbers, addresses, phone numbers, and email addresses.

However, many online merchants now work with security software companies that scan the HTML of public-facing eCommerce sites to find malicious scripts, making it harder for threat actors to stay hidden.

To evade detection, the threat actors are now injecting malicious scripts directly into the site’s payment gateway modules used to process credit card payments on checkout.

As these extensions are usually only called after a user submits their credit card details and checks out at the store, it may be harder to detect by cybersecurity solutions.

The campaign was discovered by website security experts at Sucuri after being called in to investigate an unusual infection on one of their client’s systems.

Targeting payment gateways

WooCommerce is a popular eCommerce platform for WordPress used by roughly 40% of all online stores.

To accept credit cards on the site, stores utilize a payment processing system, such as Authorize.net, a popular processor used by 440,000 merchants worldwide.

On the compromised site, Sucuri discovered that threat actors modified the “class-wc-authorize-net-cim.php” file, one of Authorize.net’s files supporting the payment gateway’s integration to WooCommerce environments.

The code injected at the bottom of the file checks if the HTTP request body contains the “wc-authorize-net-cim-credit-card-account-number” string, which means it carries payment data after a user checks out their cart on the store.

If it does, the code generates a random password, encrypts the victim’s payment details with AES-128-CBC, and stores it in an image file that the attackers later retrieve.

Malware code added at the bottom of the file
Malware code added at the bottom of the file (Sucuri)

A second injection performed by the attackers is on “wc-authorize-net-cim.min.js,” also an Authorize.net file.

The injected code captures additional payment details from input form elements on the infected website, aiming to intercept the victim’s name, shipping address, phone number, and zip/postal code.

Evading detection

Another notable aspect of this campaign is the stealthiness of the skimmer and its functions, which make it particularly hard to discover and uproot, leading to extended periods of data exfiltration.

First, the malicious code was injected in legitimate payment gateway files, so regular inspections that scan websites’ public HTML or look for suspicious file additions wouldn’t yield any results.

Secondly, saving stolen credit card details on an image file isn’t a new tactic, but strong encryption is a novel element that helps attackers evade detection. In past cases, threat actors stored stolen data in plaintext form, used weak, base64 encoding, or simply transferred the stolen information to the attackers during checkout.

Thirdly, the threat actors abuse WordPress’s Heartbeat API to emulate regular traffic and mix it with the victims’ payment data during exfiltration, which helps them evade detection from security tools monitoring for unauthorized data exfiltration.

Abusing Heartbeat API when exfiltrating data
Abusing Heartbeat API when exfiltrating victim data (Sucuri)

As MageCart actors evolve their tactics and increasingly target WooCommerce and WordPress sites, it is essential for website owners and administrators to stay vigilant and enforce robust security measures.

This recent campaign discovered by Sukuri highlights the growing sophistication of credit card skimming attacks and the attackers’ ingenuity in bypassing security.

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

WORDPRESS

Internal Linking for SEO: The Ultimate Guide of Best Practices

Published

on

Internal Linking for SEO: The Ultimate Guide of Best Practices

Are you looking for the best practices to maximize the SEO benefits of internal links?

Internal links play an important role in search engine optimization (SEO). They help search engines discover your content and rank them higher in search results.

In this article, we’ll list the best practices to use for internal linking for SEO.

How Does Internal Linking Improve SEO in WordPress?

Internal links are links between posts on your own website. Having internal links is important for your WordPress SEO. They help search engines like Google crawl your website and discover new content to index and rank.

Generally, the more links a page has pointing to it, the more likely it is to rank higher in search results. That means that you can use internal links to point to important pages on your site as a way to increase their traffic.

Internal links also help your visitors easily find related articles and provide a better user experience overall. This can also help increase pageviews and reduce your bounce rate.

That being said, let’s take a look at the best practices for improving SEO by adding internal links in WordPress. Since this is a comprehensive guide, we have included a table of contents for easier navigation.

1. Make Internal Linking a Habit

We recommend that you make a habit of linking to your older articles from your new articles.

It’s a great way to develop a contextual relationship between your new and old posts. It also allows you to pass relevant link juice to your older articles.

Because internal links play such an important role in SEO, we have even made it part of our pre-publish blog post checklist for WPBeginner writers.

You can also edit your older articles to add links to your newer content whenever you publish. Many successful bloggers dedicate time to adding internal links that point to new articles on a weekly or monthly basis.

This will help you boost your pageviews, increase the time users spend on your site, and ultimately will improve the SEO score of your individual blog posts and pages.

WordPress makes it easy to search for your old posts right inside the post editor. Simply select the text you want to link and click on the link button in the toolbar that appears.

A text pop-up will appear below your highlighted words. Then, you can start typing to search for the older articles you want to link to.

Add a Link to a Post

To learn more, see our beginner’s guide on how to add a link in WordPress.

It’s helpful to see your website’s SEO performance in terms of links by using a tool such as the Links Report in Google Search Console. This is a helpful starting point for working out how to improve internal linking on your site.

Filter internal links

The Links Report will show you how many pages are linking to this page. You can compare it with other pages and see whether pages with more internal links are ranking higher than posts with many internal links.

If you find that posts with more links do rank higher, then you can go ahead and start adding internal links to pages that you want to rank higher. For the details, see our guide on using Google Search Console to effectively grow your website traffic.

Just make sure you are only linking to the article when it makes sense. Adding links where they don’t make sense creates a bad user experience.

Another way to monitor the impact of internal linking is to see which keywords are gaining or losing position. All in One SEO makes this extremely easy with the Search Statistics feature.

Once you connect the plugin with Google Search Console, All in One SEO will fetch your Google Search Console data and present it under All in One SEO » Search Statistics.

Search statistics dashboard

The keyword positions chart shows a graph of your site’s keyword positions.

Below this, you’ll see the Keyword Rankings overview box. This shows your top 10 keywords, and if you use them for internal links they are very likely to be clicked.

keywords overview

3. Improve Your WordPress Site’s Internal Linking With a Plugin

If you’re not sure which posts you want to link to, then you will often find it faster to add internal links in WordPress using an internal linking plugin.

We recommend using All in One SEO. It includes a unique Link Assistant feature that lets you add links to your old and new content without having to open up the post. Plus, it provides link recommendations, detailed link reports, and much more.

To set up the plugin, see our guide on how to set up All in One SEO for WordPress correctly. After that, simply navigate to All in One SEO » Link Assistant in your WordPress dashboard.

Link Assistant will crawl every link on your website and then show a comprehensive list report.

Link assistant overview

The report will show you an overview of the links with total counts for internal, external, and affiliate links. It will also show you the number of orphaned posts that have not yet been linked to from another post or page.

You can switch to the Links Report tab for detailed information on all your links. Here you’ll see a list of all your posts and pages with columns for internal, external, and affiliate links.

Links report

It will also show a number of suggestions where you can add links.

For more details, you can click on the right arrow button next to a post or page. This will show all links organized in different tabs. From the suggestions tab, you can quickly view link suggestions and add links without directly editing a post or page.

View links details

Link Assistant also helps you discover more internal linking opportunities.

You can switch to the ‘Linking Opportunities’ tab to see suggestions about how to improve the internal linking on your website, and also see the list of orphaned posts so you can add links to them.

Linking opportunities

Another plugin useful for internal linking is Semrush SEO Writing Assistant because it can help you keep track of links inside your article.

For example, it lets you know when your article has too many or too few internal links and also suggests ways you can improve your links.

SEO Reporting Assistant Reports Issues With Links

This tool also comes in handy if you have other authors working on articles. Editors can quickly see if the article includes internal links to other posts on your website.

We show you how to use this plugin step-by-step to improve your SEO in our guide on how to use the SEO Writing Assistant in WordPress.

You can use a WordPress popular posts plugin to point users toward the articles that other users have already found helpful. These plugins automatically create a list of internal links to your most popular content.

Popular posts are usually your most successful content, which means they are more likely to increase user engagement, conversions, and sales. They are also a good opportunity for internal linking to your other less popular articles.

For example, MonsterInsights has a feature that allows you to show your popular articles anywhere on your WordPress site. You can use also use inline popular posts to show articles inside your content.

MonsterInsights Inline Popular Posts

If you want to show articles in the sidebar or at the end of your content, then you can select the Popular Post Widget. MonsterInsights even lets you display your top-performing products anywhere on your eCommerce store.

You can learn more in our guide on how to display popular posts in WordPress.

Another way to increase the number of internal links on your WordPress blog is to create roundups of your existing content. You do this by creating a new post that mentions your best articles on a certain subject to give a detailed overview of the topic.

In fact, you’re reading a post like that now.

Luckily, there are some plugins that make this job easy. For example, WP Tasty Roundups allows you to quickly repurpose your existing content into beautiful roundup posts that rank in search results.

All you need to do is type one or two keywords into the built-in search functionality, and the plugin will automatically pull images, titles, descriptions, and links from relevant posts into your roundup list.

WP Tasty Roundups

Sitelinks are a feature on Google search engine results pages (SERPs) where additional sub-pages appear under a website in the search results.

These are often internal links to the most popular pages of that website.

Google Sitelinks Example

The top 3 spots on Google get the most clicks. When sitelinks are shown for a website, it takes up the same amount of space as three regular search listings.

Having this much screen space dedicated to your site significantly increases your overall click-through rate. Simply put, more visitors will visit your website from the keyword.

While there is no guaranteed way to get Google to show sitelinks for your website, it certainly helps to create lots of internal links to your most important posts and pages.

You can learn more in our guide on how to get Google sitelinks for your WordPress site.

Link preloading is a browser technology that will load links in the background before a site visitor clicks them. This makes your website seem faster, which can improve SEO.

Because loading speed is one of the top indicators for search engine rankings and user engagement, when your internal pages are preloaded, your visitors are more likely to stay on your website longer.

They are more likely to view more pages because they’re loading instantly.

The easiest way to preload links is by using the Flying Pages plugin. It simply adds intelligent preloading to make sure preloading won’t crash your site or even slow it down.

Flying Links settings set the preloader delay

We show you how to set up the plugin step-by-step in our guide on how to preload links in WordPress for faster loading speeds.

Broken links are bad for your website’s SEO. Search engine crawlers find new content on your website by following internal links, so a broken link can stop them from indexing a new post.

They also negatively impact user experience because broken links will return a 404 error. If a visitor clicks on a link and is unable to find a page they’re looking for, then they may leave.

The MonsterInsights custom 404 error design

You can easily find and fix broken links on your WordPress website using All in One SEO.

AIOSEO offers a powerful redirection manager that helps track 404 errors on your website and lets you set up permanent 301 redirects to fix broken links.

404 error logs in AIOSEO

To learn more, see our detailed guide on how to find and fix broken links in WordPress.

If you ever move your WordPress site to a new domain name, then it is important to update all internal link URLs. Otherwise, you will have lots of broken links.

You should start by changing the WordPress address and site URL by visiting the Settings » General page from your WordPress dashboard.

Change the WordPress Address and Site URL to Your New Domain

But you will also need to change the URLs of every internal link added to your posts and pages.

You’ll find the simplest way to do this in our step-by-step guide on how to easily update URLs when moving your WordPress site.

If you want to make internal linking a habit, then it helps to use the most efficient method. Since WordPress 6.0, WordPress has supported standard MediaWiki syntax to quickly add internal links when creating or editing a post.

You can now quickly add links by adding two square brackets followed by the post title. The animated gif below shows you how easy this feature is to use inside WordPress.

Add link shortcut

The link will automatically add the correct URL to the post, and use the post title as an anchor link.

If you know the title of a post (or even just part of it), then using the double square bracket method is the fastest way of creating an internal link.

One of the best ways to uncover how users interact with your website is to track which internal links your visitors are clicking. Tools such as MonsterInsights can help you see which internal links your visitors are the most interested in.

overview report in monsterinsights

You can then use these insights to improve the way you add internal links to your posts and pages.

We offer detailed instructions on tracking different types of links in our guide on how to track link clicks and button clicks in WordPress.

You might also like to see our guide on how to track user engagement in WordPress.

12. Enable Breadcrumbs in WordPress or WooCommerce

Breadcrumb navigation is a term used to describe a hierarchical navigation menu presented as a trail of links.

It’s often used as a secondary navigation that allows users to go up in the website’s hierarchy of pages.

Navigational links preview in WPBeginner

Breadcrumbs are great for internal linking because they define a clean path or trail to the page you are on.

These breadcrumbs also appear in search results giving your site an extra advantage in rankings.

Breadcrumb Navigation Links in Search Results

We cover two ways to add breadcrumbs in our guide on how to display breadcrumb navigation links in WordPress. Most users will find Method 1 easier, using All in One SEO.

The AIOSEO Breadcrumbs Settings Page

You can also use All in One SEO to enable breadcrumbs for your WooCommerce products. For details, see the fifth tip in our guide on WooCommerce SEO made easy.

We hope this tutorial helped you learn how the best internal linking practices for SEO. You may also want to see our ultimate WordPress security guide, or check out our list of tips on how to increase your blog traffic.

If you liked this article, then please subscribe to our YouTube Channel for WordPress video tutorials. You can also find us on Twitter and Facebook.

Source link

Keep an eye on what we are doing
Be the first to get latest updates and exclusive content straight to your email inbox.
We promise not to spam you. You can unsubscribe at any time.
Invalid email address
Continue Reading

Trending

en_USEnglish