Skip to content

eStyle Inventory Import

Action: eSTYLE

This form is used to download eStyle style codes into the ProfitSystem.

You can download the styles, sizes charts, and color charts for your eStyle vendors into the ProfitSystem. Your eStyle id and password must already be set up in Setup->General Setup->Stores->Integration tab under eStyle Central.

The program automatically creates a backup of your inventory just before backup. If you need to restore this backup, contact BBL Systems customer service.

  1. Go to Setup->Import Data->eStyle Retail import.
  2. The ProfitSystem will ask 'Get new since date' or 'Get all styles' If you know that you only need styles added since a specific date, use 'Get new since' and enter the date. This will speed up the download. Click 'Get all styles' to download all styles from eStyle. Be patient, it can take a few minutes to download all the styles.
  3. The program will download all of the vendor styles, color charts, and size charts for all the vendors on eStyle central that you carry.
  4. You will then be shown a list of the eStyle Central vendors and brands, along with the category that the vendor carries. Since the eStyle Central vendors may not match your vendor names/numbers, you'll want to match the eStyle Central vendors with yours. For each eStyle Central vendor, click the lookup button and select the matching ProfitSystem vendor. If the vendor does not appear in the ProfitSystem, click Cancel, add the Vendor manually, and return to the eStyle Retail Inventory Import to continue. Once you've matched all the vendors, then go through and match the eStyle categories with ProfitSystem categories and accounting classes. It is best to have a matching vendor in ProfitSystem for each eStyle vendor/brand, 1 to 1. In other words it is best not to use the same ProfitSystem vendor for multiple eStyle brands. A example: Mon Cheri who has multiple designer lines. eStyle would have a different vendor name for each but you may wish to use the one Mon Cheri vendor for all.
  5. The grid will be filled with the inventory from all the vendors.
  6. The Status column will show New if this style does not appear in the shop inventory. It will show Imported if it already exists in Inventory and has already been linked to eStyle. If the style already appears in inventory, but has not been linked to eStyle, it will show Needs Import.
  7. Click on the checkbox in the Import? column to select which styles will be added to the shop inventory.
  8. Select all styles...Checks the Import? checkbox for all styles in the grid.
  9. Select styles not carried...Checks only the New styles.
  10. Select a vendor in Limit to vendor or a brand in Limit to brand to only display styles from that vendor or brand. Many vendors have more than one brand or line. In this case, the vendor is the same for all the styles, but they wil have different brands.
  11. Once you have selected all the style to load, click Import.
  12. The checked styles are added to the inventory.

Status definition * Need Import - means it's in ProfitSystem, but not linked to eStyle. * Imported - means in ProfitSystem and linked to estyle. * New - means on eStyle but not in ProfitSystem inventory at all.

There are four options that can set before importing'

During import, reset all size/color charts?...Each style imported has a linked size and color chart. These are downloaded when the style is first downloaded. If you need to reset the size/color charts for a style, you can check this option.

During import, update images for styles already on file?...If checked, any existing images for the style will be removed and replaced with the current images from eStyle Central.

Don't recompute retail prices?...if checked, the system will not recalculate the Retail 1 selling price on any items that were imported previously. Normally this would happen if the Vendor notified eStyle of a price increase on any items, and those items were then re-imported (see the section below labeled 'If an existing styles is imported, the following occurs:').

Use full length color names?...(For releases of ProfitSystem version 13.7.2 and higher). If checked, the import will use 25-character Color Name fields. Usually recommended for first-time imports.

First-time Importing vs Repeat Importing

If a new style is imported, the following occurs:

  • Store style number is auto-generated.
  • Retail factor and Retail factor plus are set using the inventory Vendor of the style.
  • Vendor style from eStyle
  • Discontinued date from eStyle
  • Description from eStyle
  • Stocked? is set to Yes
  • Reorder cost from Smart Link
  • Retail 1 price is computed as Reorder cost * Retail factor % + Retail factor plus
  • Inventory category is set to category from Smart Link, if the Smart Link category matches an existing one exactly. Otherwise, the user is prompted for the category.
  • Accounting class is set to category for the vendor and brand.
  • Store id is set to the current store
  • Size chart, color charts 1-4, and color names 1-4 are set from Smart Link.
  • Image URL is set from eStyle
  • Primary image and alternate image are downloaded and added to the style.
  • Modified is set to yes.
  • Store group is set to the store group for the current store.
  • No actual inventory is received, the QOH remains at zero and no Receive History records are created.

If an existing style is re-imported, the following occurs:

Size chart, color charts 1-4, and color names 1-4 are set from Smart Link. (Existing Colors in SCW are not affected - however the eStyle QOH synch requires the SCW color names to match exactly the color names within the eStyle color chart as provided by eStyle service (store users . When your existing/previously entered SCW color names do not match those in the eStyle color chart then the ProfitSystem Check Size/Clr Charts utility may be ran to identify those match dependencies whereby a store user may correct color names. Also when the Color does not exactly match then there will be not eStyle QOH update.

If Update images for styles already on-file? is checked, the existing images are deleted and the current images are downloaded from eStyle

  • Image URL is set from eStyle
  • The reorder cost is set from eStyle
  • Modified is set to yes.
  • Retail factor and Retail factor plus are set using the inventory vendor of the style.
  • Retail 1 price is computed as Reorder cost * Retail factor % + Retail factor plus, if the new price is higher than the existing price, it is updated. Otherwise the existing price is left.

eStyle Technical Tip: eStyle styles added to ProfitSystem Retail Inventory or existing Profitsystem styles that are matched to eStyle styles during the import will contain a eStyle ID on the ProfitSystem Retail Inventory -> eCommerce tab. This eStyle ID is how the the ProfitSystem can interact with the eStyle system for synyching QOH.

To restore the backup in foxcmd, use (table), zap, append from (estyle backup table)