Using BigCommerce to host your product-based business? We recently completed 3 programming projects for two of our clients to simplify their business processes and save them time.
Big Import
In this project, we wrote custom VBA code in Excel to parse and format the data for over 10,000 products for import into a BigCommerce site from an Excel spreadsheet.
For almost all of these products, we had to first download a product image, rename the file, then upload it to the BigCommerce server. Modification of the Excel data was hardly trivial: some fields had to be scrubbed of a number of special characters, and we had to build compatible URLs for all the images. Our client was thrilled: for several days of our work, we saved them weeks of tedious manual product entry.
BigCommerce Export to Google Adwords
Here we built an Excel workbook with VBA to reformat data from our client’s BigCommerce-based site. Our utility turned the data into a compatible Google AdWords CSV feed with “AdGroup” records, “Ad” records, and 4 “keyword” records for each product. Imagine trying to manually build all this information in Excel for hundreds or thousands of products – it would be a HUGE task. Our cost effective script saved our client an substantial amount of work.
BigCommerce Export for Order Fulfillment
This client’s BigCommerce site sells products for another company and they need to regularly send that company a fulfillment order.
We provided a utility that automates the creation of a fulfillment order to be sent to a supplier. We used the BigCommerce API to export the data which is in XML format. We then wrote macro code which took care of all of the grunt work of converting the XML to neat
column delineated data for individual orders on a BigCommerce site.
Score 3 for 3 in the time-saving department! Now its just a few clicks to send the data on its way.
Need Help with Big Commerce?
Get in touch – we are glad to quote you for projects like this which will save you time and money.