Help needed to remove $ from custom field
-
Hi All, I am an Amazon affiliate and I am attempting to sort my product displays low to high on Price which is provided in the post via a custom field “Amazon_Price” but it contains a $ thus it can not be sorted as numeric. The first step in my solution which has been completed was to add a my new custom field “price9” to each product post and manually insert the correct value without the $. This works and when sorted on yields the correct sequence of the product displays. But Amazon creates a problem for me when they change prices. My proposed solution to this involves SupraCSV. I would like to export these product posts while moving the “Amazon_Price” field to the “price9” and stripping away the $. Then import this file back into wordpress. I would run this daily via a WPCron job. The export and import steps appear to be fairly simple but the problem is with the stripping of the $. Any help with this would be greatly appreciated.
George Campbell
[email protected]
- The topic ‘Help needed to remove $ from custom field’ is closed to new replies.