We currently get product information from an XML feed that contains over 200K products (file is over 3MB). We want to import that information into an inventory management software like [login to view URL] (they allow .csv imports).
Here's example website of our product page data: [login to view URL] (please note all the tabbed descriptions. We need to pull that info from brand website)
Looking for a semi-automated approach:
- XML data pulled into spreadsheet
- Possibly use VBAs or macros to reformat data so everything matches import template
- Extra step for human to be alerted & manually review new data changes before being pushed into final export file (after VBA reformatting)
- Final formatted file will be exported to .csv to be imported into inventory management software (which then adds/ updated inventory data on Shopify & Amazon)
[login to view URL]
- also allows for FTP & API connections. Please specifify in your bid if this is a better route (building out API to connect & sync data from either XML or cloud hosted spreadsheet, we would also need a step in between for us to manually be able to update & optimize data like descriptions, categories, tags, etc before it's added through API)
Also, if you know of another inventory management software that:
- integrates with Shopify & Amazon
- allows automated bulk upload via .csv, api or FTP
Please let me know in your bid
Also, we work with over 200 brands. If you think it would be easier / cheaper to build out our own webscraping solution from their websites, please mention that in your bid. But keep in mind, most brand websites will be custom CMS & alot of data will have to be reformatted & edited before it can be used in inventory management software (updating descriptions, categories, etc). Also descriptions will be HTML. And we want to be able to reformat into tabbed descriptions to show on our website.
56 pekerja bebas membida secara purata $2283 untuk pekerjaan ini
Hi, Sir. how are you ? Thanks for posting job. I read your requirements carefully. I am sure - If you hire me then you will get best result. Let us go together. Thanks.
Hello? Nice to meet you. I am excited to work with you on this project. I am ready to start work immediately. I have good skills in those. So I think I can help you if you want. Thank you. Best Regards.