Woocommerce Bulk Attributes Version 2.3 released

Woocommerce Bulk Attributes Version 2.3 released

We are happy to release this bug fix release of our Bulk Attributes plugin.

This release fixes the issues faced since the WooCommerce 3.x upgrade and assure better compatibility.

Users who already bought the plugin are invited to download the latest version.

Release Changelog:

  • WooCommerce 3.x compatibility bug fixes
  • Minor code improvements

 

How to update your existing plugin

  1. Head to wordpress plugin menu and deactivate the current plugin
  2. Once the plugin is deactivated, delete it, don’t worry about your attributes being removed, they are safely stored in Woocommerce database tables
  3. Now download the latest plugin from your account : https://www.woocommercebulkattributes.com/my-account/downloads/
  4. and install the new version

 

How to bulk delete multiple Woocommerce attributes in phpMyAdmin

How to bulk delete multiple Woocommerce attributes in phpMyAdmin

Our plugin, allow woocommerce shop admin to add hundreds of woocommerce attributes easily to their store….Thaat’s something very cool and appreciated by our suers….

But sometimes, when using this plugin, it can happen that you add hundred of attributes terms into the wrong place (attributes). What to do then?? Here is how to get out of this….

Deleting Woocommerce attributes from phpMyAdmin

  1. Acces phpMyAdmin from cPanel

    Depending on your hosting provider, this could open in another tab, so check your pop up blocker settings in your browser.
  2. Locate the table concern by that worpdress install and click on it….then click on SQL in the top bar
     
  3. now copy and paste that sql query into the text area available in there:
    DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_attributename';

    Please make sure you repalce “attributename” with your own attribute name.

    • To find out the real name of the attributes which terms you would like to delete, go back to Products > Attributes. From there click on the attribute name, which contains terms you would like to remove.
    • In the url that will be open, something like https://www.mywebsite.com/wp-admin/edit-tags.php?taxonomy=pa_brands-models&post_type=product. In red is the real attribute name that you need to use in the SQL query.
      The query in my case is

      DELETE FROM wp_term_taxonomy WHERE taxonomy LIKE 'pa_brands-models';
  4. Run this query from phpMyAdmin to have all attribtues terms deleted ….Repeat as much as need

I hope that this little tutorial was helpfull for you….

Tutorial: Running MySQL Queries in PhpMyAdmin

Tutorial: Running MySQL Queries in PhpMyAdmin

In the enxt paragraphs, we’ll go through how to construct and run a MySQL query in PhpMyAdmin.

Depending on your personnal level of knowledge, you could have other ways of doing the same task.

Option 1 SQL tab

This one is for advanced users. There you should write in the entire SQL query  and click on the Go button to execute it.

 

Option 2 Use the Query tab

This mode allow you to have some help to build the query visually

so with this mode, you can define different search conditions, sort and filter the results and query multiple tables at the same time!

You should select the tables used in the query from the Use Tables list. The fields which will be included in the SELECT MySQL statement should be picked from the Field drop-down menus. The Show check box should be selected.

In the Criteria text field you should enter the criteria according to which the search will be completed.

Through the Sort drop-down menu you can visualize the result sorted in an ascending or a descending order.

The text window located below allows you do add extra search conditions.

Additionally, you can use the Ins and the Del check boxes to add or delete text rows for search conditions. The same can be performed through the Add/Delete Criteria Row drop-down menu. To add or delete columns use the corresponding Ins and Del check boxes or the Add/Delete Field Columns drop-down menu.

In the Modify section you can define the relations between the fields (whether they are connected through the AND or the OR logical operators).

You need to click on the Update Query button to complete the modifications.

To run the query click on the Submit Query button.

The query which we have included in our example is:

SELECT `AT_admins` . * FROM AT_admins WHERE (`AT_admins`.`login` LIKE “a%”);

It shows all the records from the AT_admins table for which the login field starts with “a”.

You can find more details about the MySQL syntax in the official MySQL Documentation.

Update : WooCommerce Bulk Attributes 2.1 is out

Update : WooCommerce Bulk Attributes 2.1 is out

We have just release version 2.1 of our plugin! Here is what’ new!

Changelog

  • Bug correction for better woocommerce integration
  • support for additionnal input list format. We now support :
    • comma separated values
    • pipe separated values
    • line (one value per line)
  • Added feature to support attributes terms assignement to product in bulk

 

Hope you enjoy it!! and don’t hesitate to share your feedback with us!

How to enable debugging mode for WordPress

How to enable debugging mode for WordPress

It is as simple as following those steps:

  •  add the following code in wp-config.php above the comment /* That’s all, stop editing! Happy blogging. */

// Enable WP_DEBUG mode

define( 'WP_DEBUG', true );

// Enable Debug logging to the /wp-content/debug.log file

define( 'WP_DEBUG_LOG', true );

// Disable display of errors and warnings

define( 'WP_DEBUG_DISPLAY', false );

@ini_set( 'display_errors', 0 );

// Use dev versions of core JS and CSS files (only needed if you are modifying these core files)

define( 'SCRIPT_DEBUG', true );

  • check the file called debug.log inside your wp-content directory. You can use this error log to identify and potential plugin conflict or other probelms.

How to add multiple attributes to WooCommerce, with hierarchy support

How to add multiple attributes to WooCommerce, with hierarchy support

If you read our previous post, you probably now clearly understand why one cannot add WooCommerce attributes one by one to it store, unless that store structure need just a few attributes.

If you are unning some bigger online store with WooCommerce and you need to add numerous product attributes and make sure they are well organized with hierarchy support, we have the tool you have been searching around ready to handle that work for you.

Previously we explained how we can add WooCommerce attributes and their terms, and configure them to support hierarchy. That was nice playing with Woocommerce attributes….Nice? it was just because we were with some sample data with a reduced number of attributes to add.

What if I have a huge list of attributes to add to WooCommerce?

In that case, you have 4 choices:

  1. Keep adding them manually as described in previous blog post, one by one 🙁
  2. Hire a somebody to do  the repetitive manual attribute entry job ….
  3. Define your attribute settings type to text; this is the only way that WooCommerce natively support adding bulk attributes terms to a product…but don’t expect attribtues terms hierarchy support with that. We will cover how to do this in detail in another post….
  4. Dive deep into WP database and use some SQL insert queries to add attributes terms as per need!

Which one fit your needs??

 

Save your day with our little handy plugin!

Those reading this post, that are SQL gurus, we recommend you stop reading… I’m noteven sure, WP DB SQL gurus are readying this……They are already deep into phpMyAdmin sending INSERT and UPDATES to WordPress internal database!

But what if you are no familiar with SQL queries?

That’s when our little plugin comes in to the rescue! Our Woocommerce Bulk Attributes plugin is here to let you do that repetitive task with less than 5 clicks…We’ll check later how many click you really need!

 

[x_prompt type=”right” title=”Buy WooCommerce Bulk Attributes Plugin for 10$” message=”Grab that little handy tool for just 10$ The little plugin that helps you add multiple attributes to WooCommerce easily” button_text=”Buy Your Copy” button_icon=”paypal” circle=”true” href=”https://www.woocommercebulkattributes.com/product/woocommerce-bulk-attributes-plugin/”]

 

How to use the plugin to add bulk attributes to WooCommerce

To help you clearly see how our plugin handle the job for you, we will continue with the example taken in previous blog post and its sample data set.

So, once you have installed and activated the plugin,

  1. Head over to Products > Bulk Add Attributes
    wcba adding bulk attributes
  2. Select the attribute you want to add multiple terms to:
    wcba adding bulk attributes 2
  3. In the first box, “add attributes” copy and paste your list of attributes terms, separated with commas.
    Then enable hierarchy support by selecting the parent term under which you need to add those term…
    wcba adding bulk attributes 3
  4. finally click on Add Term button to add those attributes terms as child term to the one specified
    wcba adding bulk attributes 4

We can check from WooCommerce attributes page if the attributes terms were successfully added as expected. Click on “Products > Attributes”

Attributes terms bulk added to Woocommerce

 

Hey, you promised, your plugin support Attributes terms hierarchy, but terms are just there in bulk!!?!

No panic allowed in here! To check if attributes were really added with hierarchy support, just click on the far left terms button

Attributes terms bulk added to Woocommerce 2

This will open another page like this, where you can see that attributes termss you added with our plugin were added as expected under the parent term!

Attributes terms bulk added to Woocommerce 3

 

How to Manually Add Woocommerce Attributes with Hierarchy

How to Manually Add Woocommerce Attributes with Hierarchy

WooCommerce Attributes…Ah our lovely attributes…

As defined by their makers, Woothemes people, now Automattic people, Woocommerce attribues are little pieces of data that you can add to your WooCommerce shop, then assign them to your Woocommerce products. Their role is to helps your users, let’s say your customers, easily search or refine your online shop catalog while browsing and searching for a product on your site.

Creating an attribute set is very simple: you create them just as you create a wordpress post category. Let dive deep in attributes and understand how, when nested with attributes support, they can give us some nice benefits, especially for our customers browsing our online shops!

 

The scenario

Let’s consider an online shop that list cell phones unlocking services. That store’s woocommerce products, are considered as “unlocking tools”. The store owner have created differents tools that deliver cell phone unlock codes to customers instantly online.

In fact they have servers behind handling cell phone unlocking algorithm and generating genuine factory unlock codes for each request….. Anyway, let’s focus back to our subject of the day: adding woocommerce attributes to an online woocommerce shop.

so each product or tool, support unlocking some specific cell phones models and brand; but also locked to some specific carriers.

Here are some sample tools or product characteristics needed. Thoses characteristics will be registered in WooCommerce as attributes:

  • Product name :Unlock Samsung UK
    • Supported brands : Samsung
    • supported phone models : Samsung Galaxy S4, Samsung Galaxy S5, Samsung Galaxy S6, Samsung Galaxy S6 Edge, Samsung Galaxy S7, Samsung Galaxy S7 Edge, Samsung Galaxy A5, etc, etc… Samsung phones models list have over 2 hundreds devices
    • supported country : United Kingdom
    • supported carrier : Everything Everywhere UK,Orange UK, O2 UK, Tesco Mobile UK, Virgin Mobile UK, Vodafone UK,3 Hutchison UK

After a few time analysing the need, we ended up setting up WooCommerces attributes and terms like theses to support the specific need of this shop:

  • First Attribute : Brands & Models
    • First level term wil be the brand name
      • second level terms will be the phones models available under each brand
  • Second Attribute : Countries & Carriers
    • First level term wil be the country
      • second level terms will be the GSM carriers in that country

 

Creating our Attributes

Here are the steps to create our attribtues.

  1. Head to Products > Attributes. It open with the “Add New Attribute” form being displayed.
    Fill in the form with the attributes needed, in our case Brands & Models, then click “Add Attribute” button

    How to Manually Add Woocommerce Attributes with HierarchyWhile creating you can choose attribute’s type and their sorting. Note you can give this a try and run later on, as these values are updatable after initial setup.
  2. Repeat that step to add the second attribute needed, in our case Countries & Carriers
    adding attributes to woocommerce
  3. Tha’t all for manually creating your attributes.

 

Let’s organize our attributes and terms with hierarchy support

So now that our attributes are ready to receive data, the next job is to insert data. In our case, you noticed that we created only 2 attributes…Why ?? This is because in our case, it was intersting to make use of the support of attributes hierarchy in WooCommerce.  We could have created 4 attributes like :

  • Brands
  • Models
  • Countries
  • Carriers

to hold the data of our products…..But we rather decied to do it like this:

  • Brands & Models
  • Countires & Carriers

So let fetch our input data sample back; this sample data is for the product “Unlock Samsung UK”

Sample Attributes Organisation Model

  • Supported brands : Samsung
  • supported phone models : Samsung Galaxy S4, Samsung Galaxy S5, Samsung Galaxy S6, Samsung Galaxy S6 Edge, Samsung Galaxy S7, Samsung Galaxy S7 Edge, Samsung Galaxy A5, etc, etc… Samsung phones models list have over 2 hundreds devices
  • supported country : United Kingdom
  • supported carrier : Everything Everywhere UK,Orange UK, O2 UK, Tesco Mobile UK, Virgin Mobile UK, Vodafone UK,3 Hutchison UK

So our data will be inserted like this (explianed previously, but let’s repeat this…). In fact, these attributes terms will represent brand name and models supported or compatible with each accessory or tool. So we have:

  • Attribute name: Brands & Models.
    This attribute will contains Attributes terms, that will be the real cell phones brands, and model.

    • Under this attributes we will add first level terms that will be brands : like Samsung, LG, HTC, Samsung, etc…
      With these first level attributes terms created, we have what we call “parent attributes terms”. We can now add child attribute terms below them.

      • So under each parent attributes terms, we will add phones model’s name, as child attributes terms. For example for Samsung, we will have as child attributes terms (under parent attribute term Samsung) models like: Samsung Galaxy S4, Samsung Galaxy S5,Samsung Galaxy S6, Samsung Galaxy S6 Edge, Samsung Galaxy S7, Samsung Galaxy S7 Edge, etc…..
  • Attributes name: Countries & Carriers
    This attribute will contains terms that will correspond to countries (as 1st level terms) and each coutries GSM carriers or operators will be considered as second level terms under each 1st level

    • USA
      • AT&T USA
      • T-Mobile USA
      • Metro PCS
      • Cricket USA
    • Spain
      • Orange Spain
      • Vodafone Spain
      • Movistar Spain
      • Yoigo Spain

 

Adding the attributes terms manually in WooCommerce with hierarchy

Adding new attributes terms is done from Products > Attribtues
add attributes terms1

  1. So let’s add the brand as first level attribute. (Go to Products > Attributes), then let’s click either on the attributes name, in our case Brands & Models”
    • insert the name of the attributes term you will like to have first level; in our case first brand is Samsung
      adding attributes term 1
    • Now let’s add the phone’s models as attributes terms of second level; they will be under the parent previously created Samsung.
      adding attributes term
      Note we have selected in parent field, the parent atttibute, in our case Samsung….
      The result of adding this is:
      adding attributes term 3
    • We will need to repeat this task as much as needed by the number of attributes terms we need in our shop structure….for this example, Samsung have over 200 hundred phones devices available….Try estimating how long it would take adding them like this
  2. We will have to repeat the same process to add supported Countries as well and supported carriers. If you understood the classic process, you should be able to organize your attributes data as our sample, like this:
    adding attributes term with hierarchy 4adding attributes term with hierarchy 5

 

That’s all for manually adding Woocommerce Attributes to your store…..time consuming huh?? We will show you in a next post how to do this easily and save your day!!

 

How To Import Bulk WooCommerce Attributes

How To Import Bulk WooCommerce Attributes

This post follows the previous one, in a series of post explaining how our WooCommerce Bulk Attributes Plugin can be helpful for a shop owner.  This post explain how to use this plugin to add multiple woocommerce attributes at once, easily, safely and even supporting hierarchy attributes terms

So we supposed, for this tutorial, that you have already installed WooCommerce Bulk Attribute plugin. And that it is already active. If not yet, grab your copy here.

 

Adding multiple attributes to Woocommerce

  1. Acces the plugin page at Products > Bulk Add Attributeshowto install WooCommerce Bulk Attribute Plugin in WordPress
  2. You will have access to this page. The page content is organized very simply to let you use the plugin in the most convenient way.woocommerce bulk add attributes plugin presentation 1

    The drop down list, allows you to select the attribute under which you want to add terms in bulk. This list depend of the existing attributes you have already created in your WordPress environnement.

  3. So we click on “Brand & Models” which is the attribute we want to add child-terms to. Once you select an attributes, the box expand to display the form that will allow you to import your hundreds of attributes.bulk add woocommerce attributes plugin presentation 2
  4. Now copy and pasted your prepared list of attributes into the box “Add Attributes”. You can also type them in, and separate each value by a comma.
    In our case, we have a list of Samsung cell phones models, we wanted to add under the parent attribute term designing the Samsung Brand.bulk add woocommerce attributes plugin presentation 3
  5. Now click on ” Add terms” Button. and the work is done in the background.
    Currently 75 child attriubutes terms were added to Samsung parent term…..woocommerce bulk add attributes plugin presentation 4
  6. We can confirm the process by going to our Woocommerce products attributes page : Products > Attributes .
    woocommerce bulk add attributes plugin presentation 5
    Attributes seems to be added without hierarchy support….???
    Just click on the button near the arrow up at far right

    attributes added with hierarchy support
    attributes added with hierarchy support

     

That’s all for today… Hope you enjoy! don’t hesitate to send us your feedback, either here in comments, or by sending us a contact inquiry from the home page!

How to Install Woocommerce Bulk Attributes Plugin

How to Install Woocommerce Bulk Attributes Plugin

Step by step WordPress Plugin installation

Plugin installation is classic for all wordPress plugins. Once you’ve made your purchase, you will receive link to download the plugin. Or you can find this url in your account on our site.

  1. Access your WordPress Phgin installation page [http://www.yoursite.com/wp-admin/plugin-install.php] or go to : Plugins > Add New.

    Woocommerce Bulk Attribute Plugin - How To install - Upload1

  2. Browse where you saved the plugin and upload it to your WordPress

    Woocommerce Bulk Attribute Plugin - How To install - Upload2

  3. Once upload is complete, Activate the plugin
    Woocommerce Bulk Attribute Plugin - How To install - Upload2
  4. You now a fully functionnal plugin that will allow you to add multiple attributes to woocommerce! And it even support Attributes terms hierarchy!
    You will find Woocmmerce Attributes Plugin in : “Products > Bulk Add Attributes”

    howto install WooCommerce Bulk Attribute Plugin in WordPress

Now you can enjoy using WooCommerce Bulk Attributes Plugin. More detail in upcoming post. We will give details about how to import attributes in bulk to WooCommerce.

WooCommerce Bulk Attributes Main Features

[cs_content][cs_section parallax=”false” style=”margin: 0px;padding: 45px 0px 5px;”][cs_row inner_container=”false” marginless_columns=”false” style=”margin: 0px auto;padding: 0px;”][cs_column fade=”false” fade_animation=”in” fade_animation_offset=”45px” fade_duration=”750″ type=”1/1″ style=”padding: 0px;”][cs_text]Woocommerce Bulk Attributes WordPress plugin is a plugin we developped to allow, WooCommerce users to add multiple products attributes in bulk to their shop.

That was a very frustrating issue among WooCommerce shop owners that were, until now, forced to add attributes one by one, and manually to their stores.

We too we faced this issue and as a result we build this plugin as an addon that will bring this nice little feature to your WooCommerce shop and ease your daily tasks![/cs_text][/cs_column][/cs_row][/cs_section][cs_section parallax=”false” style=”margin: 0px;padding: 5px 0px;”][cs_row inner_container=”false” marginless_columns=”false” style=”margin: 0px auto;padding: 0px;”][cs_column fade=”false” fade_animation=”in” fade_animation_offset=”45px” fade_duration=”750″ type=”1/1″ style=”padding: 0px;”][x_feature_headline level=”h1″ looks_like=”h3″ icon=”lightbulb-o”]Woocommerce bulk attributes version 1.5 main features[/x_feature_headline][cs_text]Woocommerce Bulk Attributes Plugin, comes bundled ith this features:[/cs_text][x_feature_list][x_feature_box title=”Insert Bulk Attributes” title_color=”rgb(68, 97, 113)” text_color=”rgb(68, 97, 113)” graphic=”icon” graphic_size=”60px” graphic_shape=”circle” graphic_color=”#ffffff” graphic_bg_color=”rgb(118, 154, 173)” align_h=”left” align_v=”top” side_graphic_spacing=”20px” max_width=”none” child=”true” connector_width=”1px” connector_style=”dashed” connector_color=”#272727″ graphic_icon=”diamond”]The plugin, once installed, allows you to insert multiple (hundreds) attributes to your woocommerce online shop. Currently, support format for the list you can insert is comma separated values (CSV file).[/x_feature_box][x_feature_box title=”Attributes Hierarchy Support” title_color=”rgb(151, 61, 52)” text_color=”rgb(151, 61, 52)” graphic=”icon” graphic_size=”60px” graphic_shape=”circle” graphic_color=”#ffffff” graphic_bg_color=”rgb(205, 96, 86)” align_h=”left” align_v=”top” side_graphic_spacing=”20px” max_width=”none” child=”true” connector_width=”1px” connector_style=”dashed” connector_color=”#272727″ graphic_icon=”bicycle”]For a better organisation of your attributes terms, we have added, in version 1.2 support for WooCommerce Attributes Hierarchy. This means you could insert hundreds of attributes terms and choose to add them as child term under another. Or even add multiple terms and set them as parent attributes terms…. Almost any combination is possible![/x_feature_box][x_feature_box title=”No Limits!” title_color=”rgb(57, 96, 74)” text_color=”rgb(57, 96, 74)” graphic=”icon” graphic_size=”60px” graphic_shape=”circle” graphic_color=”#ffffff” graphic_bg_color=”rgb(90, 170, 125)” align_h=”left” align_v=”top” side_graphic_spacing=”20px” max_width=”none” child=”true” connector_width=”1px” connector_style=”dashed” connector_color=”#272727″ graphic_icon=”envelope-o”]We often receive this question form customer asking how many attributes could they apste into the form to insert at one time…. The answer is: the number of attributes you have at hand to insert. In fact we have built our tool to support any number of attributes terms list (CSV format). The only limitation is set by your own hosting servers specifications. So don’t worry for that![/x_feature_box][/x_feature_list][/cs_column][/cs_row][/cs_section][cs_section parallax=”false” style=”margin: 0px;padding: 45px 0px 5px;”][cs_row inner_container=”false” marginless_columns=”false” style=”margin: 0px auto;padding: 0px;”][cs_column fade=”false” fade_animation=”in” fade_animation_offset=”45px” fade_duration=”750″ type=”1/1″ style=”padding: 0px;”][x_callout title=”Buy your copy now!” message=”For the launch of our plugin, we made it available for less than it’s value, to enable the majority of Woocommerce shop owners to have a working solution for this issue!” type=”center” button_text=”Buy it for 10$” circle=”false” button_icon=”paypal” href=”https://www.woocommercebulkattributes.com/product/woocommerce-bulk-attributes-upload/” href_title=”” target=””][/cs_column][/cs_row][/cs_section][/cs_content]