This Excel workbook was designed for automating many repetitive processes when I worked at this job. I taught myself Excel, Access, VBA, and SQL in order to automate my menial tasks. This project represents the beginning of my programming career. All the code is found in 'src.vba'.
The ADP Excel Sheet can tackle many frequently repeated actions such as formatting fitments, dropship reports, and bill of materials. It can also generate templates for use in uploading to Amazon, Ebay, Finale, Shipstation, GS1, or MyFitment. It features useful exporting functions to save the current worksheet without Macros or as a CSV or TXT file as well as simple email functions. Buttons are context-aware and will deactivate when their function is not applicable in the current worksheet.
After formatting, use this button to add the fitments to the AD Find Sets Database.
After formatting, use this button to add the fitments to Sixbit to use in Ebay listings.
Paste in fitments from Metro/NexPart or Sixbit. The button automatically detects where the fitments came from and renames the sheet and source appropriately. Fitments must be pasted as values into cell A1. Contains error checking but there's still a good possibility of it missing some things. In that case, manual repairs will be needed but this will still get most of the job done.
This button generates the template needed to upload inheritance information to MyFitment. This template should be exported as XLSX as that is what MyFitment asks for.
This button formats the Ebay Out of Stock page. Copy the table from the Out of Stock page in Ebay and paste as values.
This button formats Amazon Manage Inventory page. I use this feature for identifying products which have had their detail page removed (dog picture error message). In order to find all listings, make sure to expand parent listings per page first.
This button will format a Dropship report from Herko or an order report from ShipStation.
After formatting a Shipstation dropship report, this button will provide the appropriate information from a Shipstation dropship report of your choice to a Dropship Report formatting in the process.
This menu provides a few functions. It will format an "Export Products" report or a "Products sold in date range" report from Finale. Formatting "Export Products" will remove inactive products. Formatting "Products sold in date range" will prepare the sheet for inventory taking. It gives you such actions as removing any products with qty above or below a chosen value as well as removing all products except the rows chosen to keep. There's also a "Confirmed Inventory" button that adds products to a database and removes these products the next time this formatting is run in order to be more efficient when doing inventory.
This button formats Bill of Materials reports from Finale.
This button will automatically replace one product for another inside a Bill of Materials.
This button will provide a menu to choose Finale fields to add to a template to create or update products in Finale.
This button generates a template for doing a stock take in Finale.
This button generates a template for adding or updating Bill of Materials in Finale.
This button generates a template for updating Lookups in Finale.
This button generates a template for filling out a Finale product's shipping methods.
This button generates a template for adding products in bulk to a purchase order.
This button generates a template for adding or updating products to Shipstation.
The List Amazon button can generate a template for listing to Amazon if it doesn't exist in the workbook yet. Once the template exists, the List Amazon button provides an in-depth menu to provide listing information and will populate the worksheet with the appropriate formatting to upload the worksheet to Amazon.
This button generates a template for activating or updating GTINs in GS1 Data Hub.
This button generates a template for creating volume pricing in Ebay (a feature that Ebay seems to have removed). May be deprecated in the future.
This button generates a template for listing on Walmart
Clicking on the export buttons will save the current worksheet as XLSX, CSV or TXT format.
This split button has the option to Email the current worksheet as an attachment or the option to attach multiple worksheets from the workbook.
These buttons provide database connection information and version information.