Top Menu

Contents:

  1. Installation
    1. First time installation
    2. Plugin Update
  2. Settings panel
    1. WooCommerce custom fields
  3. Work with table
    1. Editor window
    2. Filters
      1. Mass update price / sales price
    3. Variations
  4. Import / Export data settings
    1. Import / Export data
      1. Images and gallery import / export settings
      2. Variations import
    2. Custom Import / Export data
    3. Remote auto-import options

 

COMMON CUSTOM FILEDS CONFIG:

 

Polylang:

polylang

Description and short description:

desc andshort desc

 

Variation description:

how to add variation description

 

Sale form / to:

sale from to

1. INSTALLATION

After purchasing product, you should install it. Make sure that you have valid WooCommerce plugin installed on your site. 

1.1. First time installation

Download your plugin package. Go to your Dashboard > Plugins and click on 'Add New'. After that click on 'Upload Plugin' and click on 'Choose file' and choose your newly donwloaded plugin package. Click on 'Install Now' and wait for installation manager to finish the job. After that click on 'Activate plugin' and you should see your newly installed plugin on your dashboard menu. You'll be asked for 32 characters length API key, so insert API key we provided to you after purchase. Plugin is now ready for use.

1.2. Plugin Update

There will often be a new versions of plugin. When there is a new version you'll get notification (Image 1.) when you enter ELPM in your dashboard and by clicking 'OK' you are downloading new plugin package. To install new version, you must go to 'Plugin' section, deactivate and then delete old one. After that install new plugin like in section 1.1. with newly downloaded package, activate it and you are ready to continue using ELPM.

update

Image 1.

 

2. SETTINGS PANEL

On plugin settings panel you can set up some basic look and functionality.

    • Fixed colums count - To make any column fixed move it to be within first [fixed columns count] columns.
    • Products per page - Max number of products to be shown on page. If your server limits execution resources so spreadsheet loads incorrectly you will have to decrease this value.
    • Enable Add - Enables adding product when importing.
    • Enable Delete - Enable deleting of product in table.
    • WooCommerce columns visibility - Check Woocommerce default colums you want to see in your table.
    • WooCommerce custom Fields - You can add some custom fields by tick "Enabled" after number of custom filed. You can set that custom field name, source type, edit options and set if it is editable for variation or not.

After all changes you made on Settings panel, click on 'SAVE' button on bottom. If you edited colums visibility, you should do

'Options'->'Clean Layout Cache' form top menu in spreadsheet editor window.

2.1. WooCommerce custom fields

You can set up to 20 custom fields from ones that are available in WooCommerce. By marking 'enable' you are enabling that field. Available properties that can be set are:

Enabled - enabled or not checkbox.

Column name - name of the columnt that will be shown in table.

Source type - will it be post field, meta value or term taxonomy.

Source - source that you select by typing available source, depend of source type you selected.

Edit options - select type and format, various of styles available.

Editable for variation - ccheck if it would be editable for variation or not.

Example of different fields (Image 1.)

custom

Image 1.

 

3. WORK WITH TABLE

3.1. Editor window

As you can see Editor window is all Excel-like so it means that you can edit and browsing data like on Excel spreadsheet. If your number of rows / columns exceeds overall height / width of your screen, you'll be able to scroll down or left-right so you can see whole table contents. 

First [fixed columns count] rows are fixed (as you set it on Settings panel). So while you scroll left / right it will stay where they are (Image 2. first 3 rows fixed - example). 

fixed rows

Image 2.

Columns are dragable and resizeable. If you want to reorder some column, go to column title cell and press and hold click on that cell very left (Image 3.). While it is pressed you can reorder that column left or right. Also if you want to resize it, go to that column title cell and press and hold click on very right of that cell while you resizing it (Image 4.).

reorder

Image 3.

resize

Image 4.

If you select multiple row / column values and click on right bottom corner of that selection, you can copy that selection to rows / columns below like on Excel. Depend of field type, you can edit , select form drop-down list, multiple select, check / uncheck it. Also you can navigate through table with keyboard arrows (Image 5.). 

navigate

Image 5.

If you selected 'Enable Delete' in settings panel, when you hovering fixed fields columns or above row numbers you'll see cross-stitch on very left. By clicking on it you are deleting that row (Image 6.).

delete 

Image 6.

All changes that you make on table can be easily undo / redo with top bar functions. There is undo / redo option, Clone option - you can clone  selected row(s) just in one click, Delete - delete selected row(s). Active data search is used to search entire table for string, there is number of found elements and that elements are highlighted. Top bar (Image 7.).

top bar

Image 7.

3.2. Filters

In editor window, on right side you'll notice Filters bar. You can hide / show it by clicking on arrow above Filters label. It is shown by default.

You can filter your table result by SKU, Product Name, Category, Tags, Shipping class, Product Status, + attributes fields. After choosing filter options, click on 'Refresh' on top of filters bar to show filtered results (Image 8.).

temp

Image 8.

3.2.1. Mass update price / sales price

Another great feature that is located in Filters bar is mass update by criteria. You should define some criteria with this format [+/-]X% or [+/-]X (where X is value) and then you can update all filtered price or sales price, depend what button you click on. 

Example:

+20% then click on 'Mass update price' - it will update price of filtered product and increase it for 20%.

-52 then click on 'Mass update sales price' - it will update sales price of filtered product and decrease sales price for 52 of default currency value.

 

3.3. Variations

You can easily add variations for every product that have Product type set to 'variable'. There is row called 'Add Variation' and if product is variable, you can click on add variations and add variations by attributes. You can set attribute values immediately or you can choose it later, also you can set number of variations you want to be added but you must choose 'Set later in spreadsheet' for at least one variation value. Also you can set 'Do not variate' if you don't want to variate by that field (Image 9. example of pop-up). NOTE: If you want that each variation be available in shop front, you must declare it's price.

pop up

Image 9.

 

4. EXPORT / IMPORT DATA SETTINGS

 

 

4.1.  Export / Import data

With our plugin you can easily import or export your products data. 

By clicking on 'Export/Import' -> 'Export CSV' your browser will download .CSV file of your products.

By clicking on 'Export/Import' -> 'Update form CSV' new panel will open. There you select .CSV file you want to import. If you edited file (in MS Excel, Libre Office or any spreadsheet or text editor), make sure you saved it in correct format 'CSV Comma Delimited (*.csv)'. Also if you thicked 'Enable Add' in Settings panel and if you are adding product with importing .CSV, make sure that 'id' field is empty. If everything is prepared well, click 'Import' and wait for products to import.

 

4.1.1. Images and gallery import / export settings

Our plugin gives you ability to import and export images with CSV file. When exporting there is url to your image in images row, and urls of images separated by comma in gallery row. When importing images you should input full valid url to your product image in 'image' row of CSV and full urls sepparated by comma for 'gallery' images row.

 

4.1.2. Variations import

If you want to create new variations with products import you need to set 'parent' column of that new variations. That field will conatin information about parent product (that must have Product type set to 'variation'). Field should be set choosing one of next rules:

Recommended if there is parent product created:

id:id_of_parent     where 'id_of_parent' is parent id, example: id:555 

If there is not parent product also (you creating it with its variations too) you should use some of the following, where SKU is recommended:

sku:sku_of_parent     where 'sku_of_parent' is parent sku, example: sku:S04

slug:slug_of_parent     where 'slug_of_parent' is parent slug, example: slug:living-room-table

title:title_of_parent     where 'title_of_parent' is parent title, example: title:Living Room Table 

Also make sure that in CSV file you will import, variations are ordered in rows right after their parents.

 

4.2. Custom Export / Import data

By going to  'Export/Import' -> 'Custom import/export settings' new panel will open where you can customize your Import / Export file format.

First if you want to enable custom export / import please check '

Custom import options:

  • If not found in CSV change existing product status to 'Pending' - used when importing CSV that contains full product list.
  • For imported products override status: - select one of stastus from dropdown for product override, also used when importing CSV that contains full product list.
  • Thousand separator is '.' decimal is ','.
  • CSV delimiter: - sets CSV delimiter for import, default is ','.
  • Use custom import format - enables / disables custom import.
  • First row is header row (skip it) - set if first row in your CSV is header row and you want to skip it.

Custom export options:

  • CSV delimiter: - sets CSV delimiter for export, default is ','.
  • Use custom export format - enables / disables custom export.
  • Input columns one by one in order your CSV file will export - select columns you want to export, must include ID or SKU.

4.3. Remote auto-import options

In 'Export/Import' -> 'Custom export/import settings' there is option to allow remote input. 

'Allow remote import' enables / disables remote import. IP address should be comma separated if there is multiple IP addresses.