Bulk Edit of Attributes and Variations

Bulk Editing of Variations and Attributes

We now support all of Etsy’s new inventory points.   It is always good practice to try this on a few listings first to make sure the results are as you expect.  Zetsy supports running these listings on draft listings.  Draft listings are a good way to explore the various options.

Both Variations and Attributes start from the same form.  When you first enter the form you can either load a previously saved group OR create a new group.  When entering a new group the taxonomy of the listings need to be decided.   With Etsy Inventory, the Taxonomy decides on what options are available.   Each group name can have one series of attributes and one series of Variations.  You do NOT have to fill in both sections.

it is important to select the listings you wish to operate these functions on first.

There are two videos up on youtube going over some of the simpler aspects of variations and attributes.

A simple one variation bulk upload is shown here :

You can also do attributes from the same screen,  A simple attribute change is shown here:

The above are simple examples.  You can add two variations if desired.

If you have distinct prices on variations the second price MUST be the difference or addition to the first price.   This is a bit different than the way Etsy handles it in these cases.  If the second variation has no price changes enter nothing.   An upcoming video will be demonstrating this

 

 

Zetsy as an Etsy shop backup program

Unlike most of the Etsy apps, Zetsy creates a database file of your shop at the time of the last sync.   The name of this file is your shop’s name followed by “_auto”.   For instance our shop’s name MiladyCreations would have a backup file name of “MiladyCreations_auto”.    Each shop’s name has its distinct backup.   All these backups are located in the standard document folder on all Windows systems with the sub directory Zimpro (our company name).    The auto backup is standard and allows a much quicker syncing of your shop rather than downloading it over time.    Zetsy can be used with other programs and simply be used as a “backup” of your shop.   Your entire shop can be backed up to your local drive and then retrieved locally.

You can make multiple backups of your file corresponding to different times.   We would strongly recommend you do this since everytime you sunc the shop you update the “_auto” backup file with the latest from Etsy.   How do we do create multiple backups?  Choose the menu option Create database.   A Save as dialog will appear and you simply add the name you wish

 

The database file has now been created.   Now Sync your shop and all the shops data will go to this database.   You can tell this because upon successful completion the title bar at the top will show what database file is currently opened.  It will also show this as the Open File name

Now close the program and restart.   Upon restart you can now open this database and retrieve all of your shops information.  Most of the editing function in Etsy support Manual Change.  In the case of a backup you would choose Manual change and then simply update.  The update uses the saved information from the database and uploads them to your shop.   An example of this is shown below.

There is a wealth of information in the saved database.  The database is from Microsoft Access and you can use that program to explore its various features.  A blog topic on the Zetsy database is here http://zimpro.co/blog/details-on-the-zetsy-zet-file/

Auto-Renew Function

The choosing of the listings for auto-renew can be done a couple of different ways.  The following video shows the set-up of a few listings for auto renew using the universal filter feature of the program..

The video shows the following set-up.

After adding listings to the grid, choose the increment renew time by using the drop down box.  After this choose the offset time with the next drop-down box.   To the right of the drop-down box is the button to enter these times into the grid.  Note that we have populated the grid now with a To-do time and date.  To the right of this is the completion time and Completed check.   The Ecode box will ONLY be filled if an error was recorded by the renewal.  A successful start of the auto-renew function is shown below.  A description of the inputs needed are:

(1) Increment renew time by.   This is the time between each renewal.   The time between each renewal is given down the To Do time column.  There is a wide range of selections available.

(2) With a Start Time of.   The lag time before the renewals begin.  The initial time is given at the top of the To Do time column.

After entering each of these times, choosing the <Add Times> button will populate the To Do Time column with the scheduled renewal time.  If you make a mistake, choose the <Clear Que> button to clear all of the times.

For each of the listed columns or input boxes, if you allow the mouse to hover over the column a tool tip should pop up giving a description of the item.  For instance the first column Proc shows this refers to Processing Time order.

Now the next video shows auto-renew in action and how you can tell that everything is working.  Note in the program tray, lower left hand corner that the auto renew symbol is displayed.   What is not seen in the video is that when renew takes place, a notice is displayed at the very right hand bottom of your screen.   Auto-renew will continue to run until q time unit AFTER the last listing renewal.  At the end you can either erase the list or start again.

 

You can check whether these have been renewed immediately by going to your listings page.  I’ve highlighted the two listings that were renewed in the auto-renew function.   At the beginning these had expiration dates of Nov. 4th

 

 

Details on the Zetsy (*.zet) file

This post is addressed to those curious about the file structures used by Zetsy and whether they can be accessed.   First make  sure a basic understanding of the program is known.   Further information on this cna be found at  zetsy-operation-and-features/.

Behind the scenes of Zetsy is a Microsoft Access database that contains all of your store’s downloaded information.   The relevant files can be found in the My documents folder with Zimpro as the subfolder (Zimpro in case you wondered is the name of our little family company).     In the Zimpro folder you will fins all of the saved Etsy store files (labeled as *.zet files).   An additional  subfolder named Pics is also contained here.   The subfolder Pics contains all of the images which have been downloaded.     The images all have numerical names.   These numerical names correspond to the image listing numbers maintained by Etsy.   The Zetsy database contains links to all of these images.   There are two types of image listings, a small image file used in Zetsy for viewing listings in the tables and those ending in _full.   Those image files ending in _full are the full image files of maximum resolution loaded into Etsy.   These are the files that should be used for archival purposes and for image manipulation.

An example of the Zetsy Access database is shown below for the image lists.   On the left side are all of the tables in Zetsy.  The table loaded is the ImageListings with the hyperlinks to these both on the internet and the local files.   I have not really geared these tables for normal user use.   This is a normal Access database and with the documentation that can found at https://www.etsy.com/developers/documentation most of the information here can be followed.   The link is the developer documentation that Etsy provides.   The Zetsy database follows this structure for the most part, but there are differences.

Zet_Access

It is obvious when looking at the Access 2013 screen above that the current user-interface of Zetsy is modeled after this.   (That of course is both a strength and a weakness!)

There are two portions on the main screen that are important for the database.  The top arrow is a button which shows for each listing how many images are downloaded.  The default setting is for all of the image listings to be small.  Clicking on this button gives access to how many and the size of these images.   Downloading all of the images as full size will of course take longer than any other option.  The lower arrow points to a checkbox which determines whether the database is automatically created and updated.   If the database is automatically created the file file is saved as your YOURSHOPNAME_auto.zet in the Zimpro directory as described above.

DB_options

 

Batch Editing of Tags

With Zetsy there are many ways of looking at and changing a listings tags.   Unfortunately all of this power can make things somehwat complex.   You can do the following

  • * Add to tags, delete tags, replace tags, or reorder Tags
  • * View your Tags by Listing along with an image of the listing
  • * Filtering by one or more tags to find Listings that contain, do not contain, or only contain the tag in question
    * Apply a tag to many Listings in a single Action

A sample video of the Zetsy tag replace functions are shown in the video below.   This is followed by some more details of is shown in the video.

From the Main Menu open up the Batch Tag Editor. By using the Global Filter you can filter the listings to nearly anything.   In this tutorial we’ll assume that this has already been accomplished.  First Choose what you wish to do with tags :  Replace, Add, Delete, or switch the order of tags.  For this example let us replace a tag.  Simply select this in the menu.  Now how to choose what to replace.   First notice in the screen below that the Tag Text add/ replace box has been populated with relevant tags.   This is becuase we had first completed a look at the tags through the analytics feature (a blog article on this is here).

Zetsy uses many of the conventions one finds in Microsoft Office products.  Hover over the top of the column and a filter button appears.  Select the filter button and a drop down oix appears of ALL of the ietms currently selected.  Selecting one of these will filter the list of tags to this selection.

 

Selecting the word animal from this list filters the list to only those tags using the word “animal”.  To replace this tag add the words you wish to replace the tag “animal” with.  In this example we chose the words “animal tree skirt”.   Of the filtered item choose the tags you wish to change.  You can check these one at a time or click the button < Mark all Displayed>  The entire column of “Change” is now marked.  Choose the button Update Selected Tags.   All of the tags of “animal” are now replaced by the words “animal tree skirt”.  The replaced column now shows the word “animal”

At this point, NOTHING in your shop been changed.  I f you have made a mistake click the Clear Updates button and start over again.  IF what you see is correct and you wish to change these tags in your shop click the <Upload to Shop> button.   If what you see is NOT what you want select the <Clear Updates> button.

The updated tags are now uploaded to your shop.

 

Zetsy has one of the most powerful filtering functions available.  An example of this is shown next.  When selecting the filter, instead of choosing from the items in the drop down box use the custom auto filter.  This is shown next

 

we typed in Is Like  and Black % in the enter box to the right.  By this selection any tag with the word black is selected.

 

 

Filtering: Create a subset of Nearly anything. Example of Title search and replace

At the top of most of the grids presented in Zetsy is a small filter button.   This little button provides all kinds of filtering capability in Zetsy.   This filtering allows one to create a subset which allows just about anything.    Since None of this is uploaded to your shop UNTIL you select it, a mistake is always easily recovered from.   ALWAYS review the changes BEFORE uploading them to your shop!

Before the new global filtering capability, you were only allowed a few choices for filtering in each batch edit screen.  Now nearly anything can be used as a filter to create a subset of listings.    The example below is with the global filtering function, but the search functions are available on ALL of the grids of Zetsy.

Lets do a find and replace.  First Under File Ops, select Filter / Review Listings

 

This opens the following grid.  Note as you hoover over the columns a small filter button will show in the right side of the column.  On the most recent versions of Zetsy hovering over the left side row will bring-up the image in a zoom window.

If you click on this button, notice that a scrollable listing of ALL of the data in this column is shown.  At the top of this list is the word {Custom}

Click on this

 

This opens the following:

This is where nearly ANY type of search function can be used to filter the available listings.

In this case I choose “Is Like” from the drop downbox and enter CIJ*.   The star is a universal character in filters meaning take anything after this.

What this does is then pull in ALL of the titles with CIJ in the name.   Your filtered list will look like this:

 

Didn’t get what you expected?  Simply go back to the filter button and choose {ALL}

Like what you have?  Choose the button <Include all Displayed >.  This creates a series of checks in the include column.  You can manually click these include buttons as well, but if there are a lot of listings this becomes tedious.  This set of listing selections are now available in all of the batch edit functions of the program.

You can close this screen.  At the bottom of the main screen, as shown below, note that a Filtered icon is now shown.