• Bulk action for multiple products (Catalog -> Product Images -> Shuffle images)
• Specific product (Catalog -> Product edit -> Shuffle images)
• Specific integrated account(Catalog -> Product edit -> Product images -> Shuffle images at the specific account)

• Title generators create clear text. They offere very advanced options like Lengts limiting, Priority, Upper Case automation, Scramble and other. This is useful for eBay titles, Etsy tags, Amazon bullets.
• Description generators are able to create full HTML. The fully visual integrated editor allows to create any type of HTML, including links, pictures or any other media. This is useful for eBay templates, Website content etc.

• You can built as many templates as needed, and apply them on products from Catalog -> System actions menu.
• Use Title Generators to easily create content for similar items (f.i. different size / metal / gemstone variation of one Solitaire Ring)

• In the Model page, set the "Main product" as the Source, and "All products from this model" as the Destination jewelry
• In the Catalog page, use the existing results to select the Source product.
• On any stage, use the multiple item IDs separated by "," to select the destination products

Sometimes you may want to offer some of your products in a variety of colors, with different gemstones or/and metal options.

You can easily create all these variations based on current model by duplicating your product.

To duplicate a product in the Valigara, you need first to check if you have all required materials defined in the system. On the Inventory pages you can check and edit existing metals, metal purities and gemstones lists. On each one of these pages there is an "Add New" button for creating a new material if needed. In addition, on the Inventory Gemstones page you can create duplications for your existing stones, and this feature can save you time working in the system.

When the materials are ready, you can find your product in the Catalog and click the "Duplicate" icon in the  Tools on the right. In the page opened you can edit "Catalog code" - SKU for your product, make desired changes in the metals and gemstones list, also you can replace photos, edit titles, description, prices and other information. After you successfully save your changes, new product is completed.

If you use Excel for preparing products list, you can copy the product details to a new row and make all desired updates to it, including product code, metals, gemstones and commercial information as titles, prices, description and so on.

Sometimes different jewelry items in your collections can be united by the same theme or same design line and they can come together as jewelry set. When you offer one of these items to buyers, you may want to draw their attention that there are other matching (complementary) items in your store, and in that way you can increase chances for a multiple purchase.

In Valigara system there is an ability to define up to 5 complementary items for each one of your products. You can select matching items in the "Complementary" tab of each product page or can use Excel file for bulk update.

After some product and its complementary items are posted to eBay/Etsy marketplaces, the links to complementary items can be visible on the product page.

• Import - is used for adding of new products in the system. When using this form, it will be necessery to provide minimal required information about your jewelry.
• Update - update of information regarding the existing products in the system. In this case, the only required field is Valigara's catalog code. The update file can include any partial information about your products, f.i. pricing only, commercial titles only , Etsy keywords etc.

• You can choose/create as many import formats for your file that will define the relation between each one of your Excel fields and appropriate field in the system. These formats will be automatically saved both for Import and Export so it is easier to use.
• For your convenience, there are several pre-made import formats. You can download examples of Excel formats targeted for different product types, including  "Valigara-default", based of the example Excel Import file, "Fine Jewelry", "Fashion Jewelry" etc. For loose stones you can use the  "Fine Jewelry" format.  If you made some updates to the example Excel, you'll need to adjust this import format accordingly.
• To define more info in your file, you can add new columns in Excel and fill them with required data, just remember to update system import format accordingly and save your changes for further use.
• Excel formatting (Format cells) and formulas are not supported by Valigara. Before importing the file, please check that it contains values only.

In general, System Alert module is built to announce you about issues that require immediate attention, including stock quantity alerts.

When you receive a system notification saying your product/gemstone reached quantity alert value, you should take one of the suggested actions to solve the issue:

• Ignore/No action

By clicking the "Ignore/No action" button you let the system know you've already handled the issue (updated stock or removed the relevant product from selling etc.) and no additional action is needed.

• Remove from all channels

If one of your gemstones is ended in stock and you don't have it anymore, by choosing this action you will remove all the products using this gemstone from all the marketplaces in order to avoid overselling.

The same action can be chosen if some of your products is ended in stock and should be removed from selling.

After the appropriate action is taken, the alert for this specific product/gemstone is marked as read in the alerts list, and you'll not receive it again.

If you are used to take the same action each time your products/gemstones reach quantity alert value, you can define it beforehand in the stock settings:

http://manager.valigara.com/module/Stock/stock_settings/

• Ignore

This action is defined by default, it means that stock alerts will not appear on the system pages, and you should constantly review your stocks to keep them updated.

• Alert for action

Choosing this action you'll keep receiving system notifications about products/gemstones reached quantity alert value.

• Remove from all channels

If this action is defined, products/gemstones reached quantity alert value will be removed from the selling automatically and you'll not receive the system alert on them.

There are several ways to upload products images in Valigara system:

• If you have your jewelry pictures on a remote server, you can define URLs (links) to them in Excel file

• If your jewelry pictures are stored on your computer, you can upload them via "Product images upload" page:
  http://manager.valigara.com/products_bulk_images.php
  Please pay attention to the instructions for creating matching pictures names to allow bulk images upload.

One of the main advantages of Valigara system is the ability to manage common stock of catalog products on different marketplaces together with materials stock management.

Inventory - products stock

Stock management is available on the Inventory page:

http://manager.valigara.com/module/Stock/stock_products/

For each one of the catalog products quantity of currently available items in stock can be defined in the "Quantity" field. Also, you can define the "Quantity alert" for each product that will send a reminder to the system Dashboard screen when a specific item is about to end, so that you'll be able to keep your stock updated all the time.

For mass quantities update the function "Update quantities" can be used.

Products - Unrepeatable items

From our experience, not all the jewelry items can be repeated, some of them are unique and one-time products only. It's very important to avoid an overselling for this type of products, especially if they are presented on several marketplaces simultaneously.

Valigara allows to define such a product as "Unrepeatable item" and when the last one of available items in stock is sold, the product will be removed automatically from all the marketplaces.

Please pay attention, that there are some situations when a marketplace doesn't allow to remove a listing, for example, when an eBay auction listing has a bid. In the case of marketplace restrictions, the overselling for "Unrepeatable item" should be managed manually.

Inventory - metals stock

In addition to products stock the system allows to manage materials (metals and gems) stock.

In the same way as you can define "Quantity" and "Quantity alert" for ready products, you can define available "Weight" for each one of the metals you use in your work and receive low stock alerts using "Weight alert".

Inventory - gemstones stock

Valigara system offers an exclusive possibility for managing common stock of loose gemstones and jewelry items that allows you to offer the same gemstone as a loose gemstone and as a part of a jewelry item at the same moment.

For example, you have a single round diamond 0.5ct SI1 F in your stock (checked as Unique) and you posted it as a loose diamond for sale. Also, you offer for a sale a solitaire ring with this diamond. At the moment your ring is sold, the loose gemstone listing also removed from sale (if there are no marketplace restrictions).

The full information about gemstones stock settings you can find here:

http://manager.valigara.com/module/Stock/stock_settings/

Orders - Sold products

An important part of efficient stock management is revision of sold products. For each one of them you can choose a system action that seems you the most suitable for this moment. For example, you can remove the product from all marketplaces, re-post again to the marketplace it was sold on and so on.

The system also allows to define an automatic product stock management settings:

http://manager.valigara.com/module/Stock/stock_settings/

When the automatic products stock update is active and new order arrives, the available quantity of this product will be reduced automatically on all marketplaces according to the ordered quantity. For example, if you have a specific ring with available quantity 3 on eBay and Etsy and 1 is sold on eBay, so after the auto-update this ring will be in quantity 2 on eBay and Etsy.

To make automatic products stock more flexible, there are additional options:

- Order status for quantity update - you can define that the quantity update occurs or when a new order arrives or just when a paid order arrives or when your order is marked as sent so on.

- Automatic stock refill - for repeatable products you can define that when your stock for such product comes to zero, it's automatically increased up to the refill value on all marketplaces.  If auto-refill is not defined and your stock for some product comes to zero, this product is removed from all marketplaces (if there are no marketplace restrictions).

In Valigara system you can manage loose gemstone products as well as jewelry products.

To import a loose gemstone product, you need to define in the Excel a type "Loose" for it together with all other required information including title and price for each channel.

If your catalog is not presented on an online marketplace as eBay or Etsy, you can prepare the products in Excel file and import them into the Valigara manager.

Preparing Excel file

On "Products import/update" system page you can download an example of Excel format to start working with:

http://manager.valigara.com/products_bulk.php

In this file you can find most of fields that can be used to define your products technical details in very accurate way (metals and gemstones information, weights, sizes...) as well as information for marketplace listings (description, titles, prices...). Also, it's possible to add more fields to this format if needed.

To make the work with Excel more convenient, we marked all mandatory fields in red, added explanations for each field in comments and also prepared several products for example.

Importing Excel file

After Excel is ready, you can go to the "Products import/update" page and upload it using Import option.

Please pay attention that Excel formatting (Format cells) and formulas are not supported by Valigara. So before you import your file, please check that it contains values only.

On the next step you are asked to choose/create the import format for your file that will define the connection between each one of your Excel fields and appropriate field in the system. For your convenience, we prepared an import format "Valigara-default" based of the example Excel file. If you made some updates to the example Excel, you'll need to adjust this import format accordingly.

Generally, Valigara allows to define as many Excel formats as you may need. For example, format for rings that contains fields with info about ring size and sizes range, format for earrings that provides details for fastening type, earrings style and so on. For each one of the Excels you can define a matching import format in the system.

Managing products images

There are several ways to upload products images in Valigara system:

• If you have your jewelry pictures on a remote server, you can define URLs (links) to them in Excel file

• If your jewelry pictures are stored on your computer, you can upload them via "Product images upload" page:
  http://manager.valigara.com/products_bulk_images.php
  Please pay attention to the instructions for creating matching pictures names to allow bulk images upload.

• If you prefer to upload images to your products one by one, you can use the "Products images" option:
  http://manager.valigara.com/products_images.php

You are welcome to choose the most suitable way for your products images managing.

• String - short text/note, a single line. Examples of system fields: "Dimensions", "eBay title".
• Text - large amount of text. Can include special characters, end of lines etc. Example: "Description" field.
• Whole number - Example: "Quantity".
• Fractional number - Examples: "Width", "Length".
• Yes/No - Examples: "Unrepeatable", "Not for sale".
• Select Multiple - used for fields in them several values can be defined at the same time. Example: "Tags", "Etsy materials".
• Select Single - used for fields in them only one value can be selected from a pre-defined list. Examples: "eBay category", "Etsy category".
• Price - field type participating in prices calculation or pricing formulas application. Example: "Reseller price", "Amazon price".
• Length - field type for defining the lenght parameters. This field can be automatically  recalculated according to different channels requirements, in MM, INCH, FEET etc.

Image storage page allows adding images to system to future use with import.

Sometimes we require the same image to be used in several products. For example, putting for sale a ring in many sizes, when we prefer to have each size to be a different product in our jewelry catalog. Or adding a beautiful jewelry box picture to each product in the catalog... The simple way would be posting the image to each product. Which is

• bulky
• requires lot of work
• in case we decide to use a different picture, we must go one-by-one to update it in all products. 

This is why we created Image storage page. Instead of uploading the picture to each product, it is possible to store it in central place. On uploading it receives it's own link, accessible from everywhere on the Internet. Using this URL, it is possible to re-use it in any place you want, including products, templates, emails and more!