Importing a large list of ZIP codes with an associated conditional logic

  • Hey Everyone! I am a novice in WordPress and web development in general. Here’s a description of my issue:

    My courier sent me a huge xlsx file (> 200k lines and 5.7 MBs) containing ZIP codes corresponding to remote areas which, during the checkout, if one of the ZIP codes is set as the buying user’s shipping address, it needs to set an extra fee like “Remote area 20€” or something like that. The remote area fee is the same for every ZIP code and it is unlikely to change in the future.

    I tried setting a remote area Shipping zone but I honestly don’t think it’s feasible with such a large dataset nor is it optimized.

    I tried also with some other plugins like Table rate shipping and flexible shipping but none of them had the functionality to import a file to my knowledge.

    What do you think is the best way to handle this?

Viewing 4 replies - 1 through 4 (of 4 total)

  • Do the Zip codes follow a pattern? Like, for example all start with 123…? Or are they all in specific states, or regions?

    Thread Starter riccardev

    (@riccardev)

    @seank123

    Hey, thanks for your contribution. The ZIP codes do not follow a pattern, they are structured like this

    COUNTRY CODE CITY NAME START POSTAL CODE END POSTAL CODE

    AT ABFALTERSBACH 9913 9913

    {all postal codes with country code AT}

    BG ABLANITSA 5574 5574

    {same with country code BG}

    all the way to country code SK alphabetically last.

    That would make it more complicated then. It looks like you will have to add all of the codes into zones.

    You could break them up by country though – so the Austrian codes in one zone, the Bulgarian in another etc

    Plugin Support shahzeen(woo-hc)

    (@shahzeenfarooq)

    Hi there!

    Thanks for reaching out and providing the details.

    For handling such a large list of ZIP codes with a fixed remote area fee, you’re absolutely right — adding them manually to a Shipping Zone in WooCommerce core isn’t feasible. WooCommerce itself doesn’t offer a built-in way to bulk import ZIP codes or conditionally apply fees based on them.

    You can try using the following plugins to see if they meet your needs:

    If these don’t fully meet your requirements, achieving your goal may require custom development. If you need more in-depth support or want to consider professional assistance for customization, I can recommend?WooExperts?and?Codeable.io?as options for getting professional help. Alternatively, you can also ask your development questions in the??WooCommerce Community Slack?as custom code falls outside our usual?scope of support

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.

Tags