(661) 297-2249
(661) 297-2249
Supplier Inventory - Where the work gets done.
This form is broken into five primary areas of work:
- Import / Update / Posting: Supplier updates are imported and posted into your inventory.
- Grouping Items for Web Store: Organize your web page item sections.
- Pricing: Calculator / Markup / Web lookup: Powerful pricing tools.
- Other Field Settings: Data analysis, formula, calculations and batch field fill in.
-
General Ledger settings: Organize our financial analysis of sales and costs.
Home, Back, Next, Top, End, Search, Info/download Click the buttons to navigate or for more information
'Key Words List' builder
|
|
Quickly build a ‘Key Words List’ for broad or narrow categories. The list can be build from words in:
Combined words are split for better ‘Search engine’ use:
|
New queries can be created, named with an 'SI_' prefix and they will be added to this list.
This makes it easy to add very sophisticated and powerful functionality and save it for on going use.
Yahoo webstore site design is made easy with this and other Inventory Wizard tools.
Import explanation
Suppliers constantly make it hard to keep your store current by:
- adding new items,
- dropping items,
- changing prices,
- correcting mistakes.
Some suppliers will send you item update information in a file (or you can create one in Excel or a word processor) which YBIW can use to automatically import and quickly correct your inventory.
This screen, by selecting import options, has been set up to automatically:
- replace quotation marks (") with 'in' and 'am/fm' with 'AM/FM',
- add the manufacturer, item number and the words 'On Special' (if the supplier has so indicated) to the item description, and
- add the item code to the full item description (Yahoo 'Caption' field) during import.
If the supplier either marks an item as DELETED or excludes an item from his file, these items are dropped from this supplier's inventory and an attempt is made to find the next best supplier for this item and assign them as the 'Default Supplier' for this item.
New items are added and assigned to this supplier, and your costs are updated.
You can then proceed
- to organize the new items by grouping them with other similar items,
- research competitive prices filling in High/Low/Median/Mode prices,
- price your items by mark up from cost or down from retail, rounding to .95 if desired,
- analyze the results against High/Low/Median/Mode using built in filters and formula,
- batch fill in other fields (like Availability, G/L, Unit of Measure, etc) and
- export them for upload to your web store.
This can all be accomplished in minutes.
Home, Back, Next, Top, End, Search, Info/download
Grouping Items for Web Store
Organizing your items so they are properly grouped on your web store involves:
- Defining the individual groups
- Assigning a Category (most general group), a Sub-Category (final, smallest group)
- Filling in the middle groups between them.
Click the buttons to navigate or for more information
Organization of your web store for easy customer use is critical. With Inventory Wizard you can
- Filter to see all items with a particular word in the description (Phone for example) and
- Filter that group again so you see only 900 Mhz phones.
-
Double click the 'yPath' on the first item to pop up the path builder form:
When you close this popup the first item's path will be set.
Then copy and paste to set all 900 mhz Phones to the same path (:Home & Garden:Phone:900MHzPhone:).
Home, Back, Next, Top, End, Search, Info/download
Pricing Calculator: Markup, Web Lookup Click the buttons to navigate or for more information
The 'Price Calculator' makes it easy to figure out the percent markup / markdown between two prices.
When you click
the
is
calculated.
Home, Back, Next, Top, End, Search, Info/download
Google Search High/Low Prices
Accomplish in minutes what would take many hours manually: 1) Locate a bunch of competitor prices, 2) Calculate the Low/ High/ Median/ Mode prices, 3) Post them into your inventory for use in calculating your best / most profitable selling price.
Home, Back, Next, Top, End, Search, Info/download
Yahoo Price comparison: Double clicking any price field lets you do item by item research.
|
|
With two clicks you can see what other Yahoo Stores are charging. You then fill in Low and High prices, the descriptive text and you can even get a picture if you need one. When you close this form this new data will fill in your inventory screen. |
 |
Home, Back, Next, Top, End, Search, Info/download
Other Field Settings
-
You can pick any field from the drop down list. fill in any value (including formulae) and automatically fill in that field on all selected items.
This is handy for fields like Availability, Unit of Measure, or
- any field where a lot of items have the same value.
- Copying data from one column to another (EG UOM to Weight UOM)
-
You can create formula and save them for easy future use.
-
You can design and save filters also.
For example, you might not want to sell items where your sale price is above Mode so you could calculate '% Below Mode' and filter to exclude any negative percents and only upload the remainder to your Yahoo store. Or perhaps send your supplier a list of the items on which he needs to give you a better price.
Home, Back, Next, Top, End, Search, Info/download Click the buttons to navigate or for more information
General Ledger Settings
Setting up your General Ledger Inventory, Sales and Cost of Goods by Category and Sub-Category is beyond the needs of Inventory Wizard Stand alone version but when you're using the integrated Y-Books Order processing and Accounting system this capability gives you a powerful tool for analysis of profitability by Category.
Home, Back, Next, Top, End ., Search, Info/download Click the buttons to navigate or for more information