项目作者: prikhi

项目描述 :
Convert Shopify Order Exports into AvaTax Transansaction Imports
高级语言: Haskell
项目地址: git://github.com/prikhi/shopify-to-avatax.git
创建时间: 2020-02-07T21:51:38Z
项目社区:https://github.com/prikhi/shopify-to-avatax

开源协议:GNU General Public License v3.0

下载


Shopify → Avalara AvaTax Converter

Build Status

A haskell program that converts a Shopify Order Export CSV into an XLSX for
AvaTax Transaction Imports.

  1. From your Shopify admin, go to the Orders page.
  2. Filter this however you’d like(e.g., only last month), then click the Export
    button.
  3. Wait for the order export email to arrive & download it.
  4. Copy the order export to this directory, renaming it to orders_export_1.csv.
  5. Run the script using stack run.
  6. Open the generated avatax-wholesale-transactions.csv in Excel/LibreOffice.
  7. Review the generated fields & perform any necessary cleanup.
  8. Copy each generated column into the appropriate column of AvaTax’s
    Transaction Import template spreadsheet.
  9. Import the template spreadsheet from Transactions > Import Transactions on
    the Avalara website.

There’s some hardcoded stuff here that you might want to switch out if you use
it yourself:

  • Input/output file names from app/Main.hs
  • Shipping item code/name.
  • Origin region & postal code.
  • Prefixes for the customer ID & order ID.

Pull requests to abstract those out are welcome.

LICENSE

GPL-3.0+