Export Processor Does Not Find Record Due to Space in Item Number
Release: 7/2/2021
Version: 7.5 & Up
Q - I attempted to run the Exporter on the Sales History TRX looking for sales equal to 9835-GS KIT. It pulled back 0 sales. See sample screen below:
Knowing this to be not valid, I then ran the Exporter looking for anything connected to GT 9835-GS. It pulled up 30 thousand records with the 9835-GS KIT. Thinking I possibly had an extra space, I copied the item number from the CSV for the 9835-GS KIT and inserted the copied text back into the Exporter to rerun and look for items that equaled 9835-GS KIT. The system again reported 0 sales.
Why is this occurring?
A - On the second parameter:
Cphsttrx.hist_trx_item_no EQ 9835-GS KIT
Please change it to:
Cphsttrx.hist_trx_item_no EQ “9835-GS KIT”
When the item number contains a space, the system interprets the above expression to mean EQ “9835-GS” or “KIT.” Add a quote around the item number with the space to resolve this issue.
Also, in the following KB article, we discuss what special characters to avoid with item numbers. Spaces are allowed but should be avoided whenever possible:
Related Articles
Using the Export Processor to Export Data
Q: It has been a while since we used the Export Processor to Export Data from Elliott. I remember how to select the category and choose the search data, but I can't remember how to select all the fields that need to be processed for export. Can you ...Feature - Support 12 Months History in Export Processor
Release Date - 7/13/17 Note: This feature is only available in version 8.2 and above. The Export Processer now supports the 12 Month History Summary file for the following tables and values: Customers: Total sales for the customer by period Total ...How to Find a Record that Does Not Have a Certain Attribute in Export Processor
Release Date: 03/21/2024 Version: 8.0 & Up Q - Just so we're sure of ourselves over here, there is still no way to use Export Processor to find records where an attribute is NOT attached to the record, correct? We're needing to filter this way often ...CP0501 Customer Order Processing Sales History Trx Processing
Sales History Trx Processing Application Overview The Sales History Trx Processing is a standard transaction entry module allowing add, change and delete/inquire functions, as well as an edit list print‑out to verify that the transactions entered are ...Feature - A/P Simple Trx Processing
Release Date - 2/4/16 This new functionality has been added with the intention of allowing customers to import CSV files that are provided by credit card companies. This new application will allow the users to import the transactions into a temporary ...