I have a dilemma where many of my product feeds have either,
1: Sale Price Equal to the Retail Price
2: Sale Price Only
I currently have a modification that only imports the product if Sale Price is less then Retail Price, however, both records must have a value otherwise the product gets skipped without being imported into the database.
I am wondering if there is an easy way to modify PT so that in the cases where Sale Price is equal to Retail Price or only Sale Price exists I can have a new table "Retail Products" in the database where these products can be imported and all other products that have a Sale Price less then Retail Price would get imported into the "Products" table as normal?
My thoughts are that once the products are imported into the "Retail Products" table I could track down the retail prices for each product and somehow edit the prices then move it to the "Products" table and upon future imports, PT would leave the "Retail Prices" intact and untouched without deleting them.
Does this sound like a modification that could be done fairly easy? If this is not something that could be done fairly easy would you happen to have any ideas of the best way to deal with this?