SQL Query Data script for Linnworks custom report
- or -
Post a project like this$$$
- Posted:
- Proposals: 9
- Remote
- #1641096
- Expired
Magento Certified Developer | eCommerce Developer | Shopify Developer | Graphic Designer | Wordpress Developer | Website Designer
London
Magento, Opencart, Codeigniter, Laravel, AngularJS, NodeJS, ReactJS, octobercms, hubspot
Noida
17073054116063052078230012809841330084139353916460921671630
Description
Experience Level: Expert
General information for the business: We sell ~350 products actively across multiple ecommerce marketplaces including Amazon, eBay, and Magento
Description of requirements/functionality: Hi all!
Im looking for an SQL expert who knows Linnworks to develop a query data script for a custom Linnworks report.
Explanation: I want to see weekly stock consumption rates (WSCR for shorthand for rest of description) for all SKUs across all channels for all 52 weeks of the trailing twelve months.
Columns:
SKU | Source | Subsource | WSCR Wk1 | WSCR Wk2 | WSCR Wk3 | etc | ...
——————————————————————————————————————
EXSKU-1 | AMAZON | AMAZON FBA | 1.2 | 1.5 | 1.45 | etc | ..
I'd also like a few variations to query averages and totals of price/revenue instead of WSCR as well as a few variations to group the data by SKU categories, and source and subsource.
Intent: I want to improve our inventory forecasting abilities by enabling us to see seasonal trends, stock outages, and velocity and price elasticity across subsources.
Looking forward to seeing proposals.
Thanks!
Hunter
Extra notes: Please provide details about your programming experience and expertise. We have many more small software development projects to execute.
Description of requirements/functionality: Hi all!
Im looking for an SQL expert who knows Linnworks to develop a query data script for a custom Linnworks report.
Explanation: I want to see weekly stock consumption rates (WSCR for shorthand for rest of description) for all SKUs across all channels for all 52 weeks of the trailing twelve months.
Columns:
SKU | Source | Subsource | WSCR Wk1 | WSCR Wk2 | WSCR Wk3 | etc | ...
——————————————————————————————————————
EXSKU-1 | AMAZON | AMAZON FBA | 1.2 | 1.5 | 1.45 | etc | ..
I'd also like a few variations to query averages and totals of price/revenue instead of WSCR as well as a few variations to group the data by SKU categories, and source and subsource.
Intent: I want to improve our inventory forecasting abilities by enabling us to see seasonal trends, stock outages, and velocity and price elasticity across subsources.
Looking forward to seeing proposals.
Thanks!
Hunter
Extra notes: Please provide details about your programming experience and expertise. We have many more small software development projects to execute.
Hunter L.
97% (13)Projects Completed
10
Freelancers worked with
9
Projects awarded
8%
Last project
9 Aug 2018
United States
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies