The client has made the following changes to the job.
Client prefers freelancers from:
You are still able to submit a proposal for this job.
The client prefers freelancers from
a different location.
First, let me describe each file I attached here for you.
1 - backup_products...... - This is my sample inventory exported to Excel from OpenCart.
2 - Backorders - This comes from my supplier and lists the items that are on back-order as well as the ones that are no longer on back-order.
3 - Clearance - This comes from the supplier. These are items that have limited availability.
4 - ProductFeed - this is the main product feed that comes from the supplier. I cut out most of the rows on this file, as it is a VERY large file.
You should note the the column SKU on the productfeed file and backup_products file and the Column ItemID on the Clearance and Backorder file are one and the same.
In essence, I would like to be able to run a report that does the following actions:
Based on my current inventory via the SKU.
Report 1 - Compare the items that are currently on Backorder to my inventory, report the results, change the the Quantity field (in the backup_products file) t...
Sign in or Register to see more