Categories: Tips and Tricks
Each month, we offer up a trip or trick on how to maximize the value of your WarehouseTWO subscription. Here are the monthly tips for 2016.
January: Schedule your automated inventory data downloads (from WarehouseTWO’s server to your target FTP server) for between 4:00am EST/EDT (08:00 GMT for EST, 07:00 GMT for EDT) and one hour prior to your scheduled start of business. Doing so will capture the most currently posted inventory data, while making it available to your ERP system prior to the start of your business day.
February: Schedule your inventory data imports into your ERP system between ten minutes after when your export of data from WarehouseTWO’s server occurs and one hour prior to your scheduled start of business. This will ensure that the freshest data will be in your ERP system when your employees start their workday.
March: Searching by Description is a key word search only. For example, entering “hose” into the description field and then clicking the SEARCH button will yield every item for which the discrete word, “hose” appears in the description of the posted item. The result will not include items that include the words “chose” or “those” in their description fields.
April: When performing an "Exact Text" search, the percent sign (%) is a wild card character. For example, performing an "Exact Text" search on the part number string "ABC%123%" will find all part numbers that start with the string "ABC" and have the string "123" somewhere in it. Using this wild card character facilitates finding items that have one or more desired base model characters and/or option codes, and for which you do not care about other options the items may or may not have.
May: When posting inventory data records to a WEB MARKET location and to the special community, “marketplace: miscellaneous”, include a brand or manufacturer’s name in the beginning of the part number field and description field. Doing so will improve the search results in Google.
June: Do not use “forbidden” characters in your inventory data records. “Forbidden” characters, often not visible when displayed in your data file, include leading quotation marks, carriage returns, pipe characters (|) and tabs. For example, if your item description is displayed in more than one row, it probably includes a carriage return.
July: When faced with minimum order value requirements imposed by sellers at WarehouseTWO, consider these actions:
August: Add details to your BROADCAST REQUEST email. The body of a BROADCAST REQUEST email is a free-form text field. Before clicking on the SEND button, edit the message box by adding information such as quantity needed, whether or not you would accept partial quantities, whether or not you would accept substitutes and any other requirements you may have.
September: Auto-delete out-of-stock items by uploading the part number with a “zero” (0) quantity. If you can identify items for which you “stocked out” since your last nightly data upload, you can send additional uploads that contain these “recently stocked out” records and assigned a quantity of “zero” (0) to them. Upon receipt of such an update file, these records will be deleted from our system prior to your selected expiration period, such as “After 7 Days”.
October: Populate the “Location Identifier” field in your user record. This is a new field, as of September 2016, and is therefore empty for most users. Entering valid location information into this field will activate our new “Distance to Seller” functionality on the SEARCH and MULTI-SEARCH screens.
November: Populate the “Location Identifier” field in your location record(s). This is a new field, as of September 2016, and is therefore empty for most locations. Entering valid location information (i.e., one that is available in the drop-down list of locations available in this field) will improve the accuracy of our new “Distance to Seller” functionality on the SEARCH and MULTI-SEARCH screens.