Invoices numbering is messed up

[saraseiva]

Hi, im using shopify and other platform synchronised with shopify to sell items.

For example, after getting an order from shopify ,it generates an invoice number DL0001, the second order comes from the selling platform and invoice number is already BOL9990183687, the third order comes directly from shopify and its invoice is generated as DL0003.

How could I fix it that the numbering would be sequenced, doesnt matter where the order is coming from?

Thanks

[akshay_bhatt]

Hi @saraseiva ,

To have a sequential invoice numbering system across both Shopify and your external selling platform, you would likely need to implement a custom solution, as Shopify's default invoice numbering is not designed to handle orders from multiple sources in a unified sequence. Here's how you can approach this:

1. Use a Shopify App to Manage Sequential Invoices

• Order Printer Pro: This app allows you to customize your invoices and set up automatic sequential numbering, and it can be used to manage multiple sales channels. You might need to configure it with a custom sequence rule across all platforms.
• Custom Order Numbers App: This app helps you configure a sequential order numbering system for Shopify, ensuring that the sequence is maintained even with multiple sales channels.

2. Custom Script or API Integration (For Advanced Users)

• Custom API Solution: You can build a custom script or app that integrates Shopify with your external selling platform. This script would track the last invoice number generated from all platforms and ensure the next invoice uses the next available number, regardless of the source.
  • For example, use Shopify's Admin API to fetch the latest order number and cross-check with the external platform's API. You can then set the invoice number based on the last known order number from either platform.

Here’s a simplified flow:

• Fetch Last Invoice Number: Query the last invoice number (whether from Shopify or the external platform).
• Increment Number: Based on the highest invoice number across platforms, increment the sequence.
• Assign New Invoice Number: Automatically assign this new number to the new order.

3. Manual Process (Short-term Solution)

• If you're dealing with a small volume of orders, you could manually adjust the invoice number each time you process an order from either platform. This is not ideal for long-term use, but it can work temporarily while you set up a more automated system.

4. External Tools or Middleware

• Consider using middleware services such as Zapier or Integromat to create workflows between Shopify and your external platform. These tools can fetch the last order number from both platforms, generate the next sequential invoice, and update both Shopify and your external platform accordingly.

Key Considerations:

• Platform API Access: Ensure both Shopify and your external platform provide sufficient API access to retrieve and update order numbers.
• Order Management System: If your external platform supports custom configurations for invoice numbers, you may be able to sync the systems more easily.
• App Customization: Some apps may require some customizations for your specific needs, so checking with the app's support team is often a good idea.

Got it! If you found my suggestions helpful, please consider liking or marking it as a solution.
Your feedback is appreciated! If you have any more questions or need further assistance, just let me know.

Thanks & Regards
Akshay Bhatt

[JuneN]

Hi @saraseiva,

To generate the invoice number in sequence, consider using our app Fordeer: PDF Invoice Generator which offers custom invoice number features. You can refer to the screenshot below: