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 ...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 ...Feature - Equal Sign Support in Export Processor
Release Date - 1/5/18 When exporting Elliott's alphanumeric fields to CSV through the Export Processor, the leading zeroes will be dropped when the file is opened with Excel. For example, when opening the CSV in Excel, item number 0100 is displayed ...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 ...Feature - Allow Web Item Flag = Space to Use Product Category's Web Flag
Release Date: 2/16/2021 Version: 8.5 & Up In the past, the flag "Web Item Flag" in Item Master needed to have a value of "Y" or "N." It is now changed to allow a space, which means use the value of the web category flag in the product category. See ...