Obtain Data from ACD Pro module via Order ID

[rajnishsi]

Hi,

I'm having a store where ACD Pro module is in work, and I'm needed to get the information it stores in 'FulfillmentModule_ProcessOrder' function. I have no idea about how it stores this information in DB and I don't have access to the store's DB either.

Has anyone ever faced something like this and got it to work ? It'd be really helpful if someone has some examples related to this module.

[ids]

You'll need to write your own query. I don't recall if ACD mod stores the order id though. Sebenza module right? Contact Brennan for potential help on ACD tables.

Scott

[Bruce - PhosphorMedia]

Since you have to interact directly with the database, I'd highly recommend porting this over to built in Basket/Order custom fields. More work now, less frustration later.

[rajnishsi]

Scott , yeah, it is Sebenza module. I'm struggling with the table definitions with this module. I sure will try to get help from Brennan .

Bruce , you are right, but the store has been using that module for years and I first need to get that old data stored in ACD tables correctly, only then I'll be able to implement custom order fields.

[Brennan]

Are you trying to pull this data in the page templates or in your module?

[Brennan]

Here is what the table structure looks like:

s0x_SS_ACEDPRO_fields
id
title
content

s0x_SS_ACEDPRO_results
session_id
order_id
basket_id
last_name
acd_id
content

However if you are trying to get this data in the page templates there is an item you can assign Invoice/emails

https://sebenza.freshdesk.com/suppor...ro-results-pr8

[rajnishsi]

Thanks Brennan, I was looking for having this via Mivascript. Got this via joins between those tables.