search

joelbrock / PFC_CORE

Peoples Food Co-op - Portland, OR
peoples.coop
GNU General Public License v2.0
2 stars 1 forks source link

sales history normalization (post migration log massage) #133

Open comfrey opened 10 years ago

comfrey commented 10 years ago

FFA and MAD Discounts need addressing total fields trans_type trans_subtype

comfrey commented 10 years ago

UPDATE transArchive201002 SETdepartment=48 WHERE upc LIKE '%ffa%' UPDATE transArchive201002 SET department=49 WHERE UPC = "MADDISCOUNT"

Next step is to create iteration based on nested migration script.

comfrey commented 10 years ago

created a file sales_normalization.php in PFC_CORE root