We have developed various tools to help the warehouse through the receiving process. These modules can be customized to your
Prompts for offer, discount, Ecometry Category, Item status, item number, increase or decrease price, and whether to create the offer item or not. Wildcards are allowed for all prompts except offer and discount. The program identifies how many SKU's match the criteria and verify's with the user if they are sure they want to continue. Upon approval the program will identify which of these SKU's have offer item entries and update the offer pricing to reflect the percentage off. If no offer pricing record exists for the item one will be created if the option was selected. Any existing multi-pricing tables would also have the price adjusted for these items. In addition a log file will be created by offer that shows all the items that were modified and what the item master price was at the time and what the new discounted price was set to. If you have a lot of criteria (any number of categories, status's, and/or SKU‟s) the criteria can be driven by file.
As with most data driven systems, there is always the need to extract data from the database for reporting purposes, export/import processing between multiple systems or for troubleshooting and analysis. Usually this can be done with a member of your staff skilled in writing Structured Query Language scripts. This is fine for a one time situation but can quickly begin to take up manpower resource quickly when this data is needed on a routine bases. This is where the Data Extract Service can help! You can take the script that you have written to extract the data you need and then have the service automate it for you.
The power of easy of the Data Extract Service is in its run scheduler. You can configure the Extract Service to execute a job for any situation. Here are some examples of how you can schedule an extract job: - Every 5 minutes - Every hour but only during the week - At 5am every Monday - During a two week period before a holiday - Every second Tuesday of the month If you need to have the data extracted in any hour, day, month configuration, the Data Extract Service can schedule it for you. The Extract Service will create character delimited files for you with the results of the database extract query and FTP that file to you. Or if you prefer, it can utilize and network access SMTP server to send you the data via email!
The HP3000 CC Encryption product allows users of Ecometry to keep credit card data encrypted in the HP3000 database without any changes required to the Ecometry software. In addition an API is available that allows any HP3000 software to use encryption.
The approach taken with this product is to intercept the database calls and watch for credit cards being stored or retrieved. If a CC is being stored it’s encrypted and if it’s being retrieved it’s decrypted. This process is only executed for programs running in the Ecometry environment. In order for a program to successfully retrieve the credit card number it must be run using the correct XL’s in the correct order.
By default the Encryption key is not stored anywhere. The key is calculated using a proprietary algorithm and every credit card stored is stored with a different key. This makes administration easy and very secure. Should you wish to set your own encryption key you can do so by using the key manager program. The encryption key stored in a binary form in the code base.
We have almost 40 years experience on the HP3000 programming in various languages. If you need software support, we can help. Either with existing software or we can develop new solutions as needed. If you're migrating off the HP we can help with that too.
We have a series of Inventory tools that do things such as bulk stock moves, bulk location creation, unassigning primary locations, and
many others. This is particularly useful when re-arranging a warehouse or moving a warehouse. If you are in need to some inventory tools give us a call. Chances are we've written something like it in the past.
The Fluent Edge Item Maintenance API is a complete and variable toolset for creating and editing products in Ecometry from outside of Ecometry. You can maintain items, aliases, keywords and upsell data automatically, individually or in bulk. Import items from one system into Ecometry with ease. Update existing item data or create new items or both all from the same input.
Item Maintenance provides you multiple means to accomplish your goals. You can use the API’s file based processing which allows you to push batch item data files to the API for processing. The files can be processed using the Item Maintenance Service which can be configured to watch a specified directory for input files, or by calling the executable. The Item Maintenance executable can be called via command line interface or from a batch file or job stream using our Job Stream Wrapper tool. You can even write your own solution using the .Net class structures provided to you via the API dlls. This allows you to integrate the power of the Item Maintenance API within your own code solutions. It just cannot get any easier than that!
The Item Maintenance API allows you to set up a default item which it will use to base all new items on. All item values are inherited from this default item and then all you have to do is change the properties that you want to be different. This makes creating new items consistent and easy. If you need to update an item, you do not need to update all of the item’s values. Just pass the values that you wish to have changed and the API will change only those items. Everything else remains the same.
When using the API in your own code, the Item Maintenance API classes provide detail error messages so that you can quickly identify any problems saving you potentially hours in development time.
We can even assist you with any custom development that you are under taking!
M.I.C.E is a web based tool that provides documentation on the Ecometry database. It includes info on control blocks, copylibs, status',Supertool definitions, and much more. Designed specifically for Ecometry on the HP3000 it is still found to be useful for those on Open Systems.
MICE is the must have tool for Ecometry administrators. Providing dataset layouts and field definitions as well as suprtool defines that you can copy and paste into suprtool. Multi-user options to allow as many people as you want in your organizaton to login at the same time. MICE by the way stands for MACS Internals Controls Etc. (direct commerce was first call MACS before Ecometry and Direct Commerce). MICE improves on your ability to solve Ecometry problems and diagnose problem orders. You can sign up for a free trial at mice.fluentedge.com
Creating item pricing for multiple offers can be a very tedious task in Ecometry. Well it doesn’t have to be a daunting task anymore The Offer Item Load Utility will create or update offer items entries and multi-pricing entries based on fixed length or comma delimited input files. A user created input file is read in and processed. If the item in the file is found then the item is updated with the data contained for that item in the file, if it is not found then the offer item entry is created. The utility can optionally update UPSELL data as well.
Call the Offer Item Load application from a batch file or via command line passing it the file containing all of the data that is needed. If find that you may need to run this process from with an Ecometry job stream job, our Job Stream Wrapper tool can help you do that too.
The input file format is simple and easy to understand so that you can quickly generate the file. If you do not have the means to create the file yourself, we can help! We can assist you in your efforts or write a custom application to help you get started to an easier way to manage Ecometry’s offer item pricing.
The Paymentech Interface consists of a Windows service which is configured to receive credit card files from Ecometry to be batch processed through Chase/Paymentech’s NetConnect processing system. The Paymentech Interface service is configured using a simple configuration administration program. This configuration application provides you not only with the tools you need to configure the Interface service to communicate with the Chase/Paymentech NetConnect system, but it also provides you with the means to easily recover from possible network related failures that can occur during file transfers. The service handles the sending of the credit card data to NetConnect and also the return file which is sent to Ecometry while kicking off the Ecometry job stream to load it. This is done automatically, seamlessly and securely. The credit card files are encrypted using industry standard encryption algorithms and send to NetConnect over secure socket connections (SSL). This means that your customer’s sensitive credit card data is double encrypted for added security.
Installation is simple and easy. Integration with Ecometry is done quickly and smoothly. Configuration is uncomplicated and straightforward.
The Paymentech Interface provides you with a dual environment setup; Test and Live. This means that you can safely configure your Ecometry Test environment for credit card processing when testing process changes prior to implementing them into your production environment.
TMeditor is an editor for TapeMacs files. Easy identification and validation of key fields. Fixing existing records and adding to ones.